Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2007

Tip: Looking for answers? Try searching our database.

URGENT : Bug in XLS budget file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Junkyard Engineer - 24 Jan 2007 16:28 GMT
I have a multi-tab budget worksheet. I run XLS03, no macro.

Now, after opening the file, when I enter a number in a cell in one of the
tab, the number appears on the other tabs at exactely the same cell
location. It happens on 4 tabs out of 8 in total. It's like all 4 tabs are
the same sheet but no links exist between them, at least not where I enter
the numbers. (links exists in other cells). It simply overwrite the other
cells. But all 4 tabs have initially the right numbers and formula in them.

I've tried to save the file under another name, open the file on a colleague
PC running excel 2003 also and I get the same results.

Previous version of the file do not show such behavior. Since tons of
changes has been entered between the actual and previous version, I
obviously don't want to go in the process of rebuilding the model.

Only visible sign of something different is that after the name of the file
in the title bar, now it's written Workgroup although I never save under
anything else than XLS file.

Any ideas ?
Pete_UK - 24 Jan 2007 17:15 GMT
Perhaps you have some sheets grouped together, so that any change to
one of them will affect the others in the group. Is the background
colour of the tabs of the sheets affected different than the other
tabs?

Right click on a sheet tab and select Ungroup Sheets, or just click a
sheet tab which is not affected in order to ungroup the sheets.

Hope this helps.

Pete

On Jan 24, 4:28 pm, "Junkyard Engineer" <jevandenbrou...@hotmail.com>
wrote:
> I have a multi-tab budget worksheet. I run XLS03, no macro.
>
[quoted text clipped - 17 lines]
>
> Any ideas ?
Junkyard Engineer - 24 Jan 2007 18:47 GMT
Pete, I just love you !

Thanks !

Weiderst part of it is that I never grouped them !

> Perhaps you have some sheets grouped together, so that any change to
> one of them will affect the others in the group. Is the background
[quoted text clipped - 37 lines]
>>
>> Any ideas ?
Pete_UK - 25 Jan 2007 19:05 GMT
Oh, your message has just appeared - even though you replied yesterday!
Thanks for feeding back - I'm glad it worked for you.

Pete

On Jan 24, 6:47 pm, "Junkyard Engineer" <jevandenbrou...@hotmail.com>
wrote:
> Pete, I just love you !
>
[quoted text clipped - 46 lines]
>
> >> Any ideas ?- Hide quoted text -- Show quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.