Excel 2002 behavior?

Question:

I created a shared workbook and each day when we open the workbook it defaults to a specific tab. Each of us get a different tab and none of us get the tab we were working on when we saved and closed our workbook. Is there something hidden in the workbook that is causing this unique and very frustrating problem? We work with 330 tabs, one for each workday of the year. For example: My spreadsheet defaults to "Mar 29" and another worker defaults to "Feb 16" and so on and so forth. I have asked this question every way that I can think of in the Microsoft Support screens and can not find anything remotely close to this problem. It was suggested that there might be a macro attached to the workbook, but I did not find any macros. Thank you in advance for any and all help with this issue. Sandy :-)

Answer:
Good question! The sheet in a shared workbook that will open is the sheet that was open when a user first saved it - subsequent saves will appear to "flash" when the user reopens - but will immediately display that very first worksheet. I believe this is the "default" behavior and can't be changed through any workbook options. I think you may be able to "trick" the setting by toggling the track changes setting from something (30 days) to don't track and then save the workbook. You can use this once for each user - then the workbook could open to the same sheet for everyone - but again this will only fool the history, and not resolve your real issue. Unfortunately, I think this is one you'll have to live with as is - good luck!

The tab that will open is the tab that was open when the workbook was last saved.

Test it. Open your workbook. Go to 1a random date like 14 Feb. Save it and close it. Reopen it and it will go to 14 Feb (assuming no one else has saved it in the meantime).

Sandy

The solution is not that difficult... You can create 2 macro

1) One that records the last tab used by each user in a special page with the user list (that can be auto generated)
2) and another in an open event that activate the last tab used

Please send me and email if you are interested, i can send you a text file with the codes and instructions

:)

Excel 2002 behavior?

Hot Topic