Hi Matt,

I am presuming that our workbook has VBA code. The developer has the option
to make the sheet very hidden. When that happens you do not see the sheet and
you do not see it in the list of hidden sheets as well.
The only way to get back the sheet is to know the name of the sheet and
issue the following command from the Immediate window.
worksheets("NameOfTheHiddenSheet").visible=true


"Matt L." wrote:

I am also having this problem with a user. One sheet of her workbook just
disappeared. We are running Office 2003 with all avaliable updates. Only two
people have access to the workbook, which resides on our Win2000 file server.
Our workstations are XP with all avaliable updates.
--
Matt L.


"Alok" wrote:

I think you are talking about workbooks while the OP is talking about
worksheets.?

"JLGWhiz" wrote:

Back when I was in the cubicle farms, we had similar problems. Here are a
couple of conditions that may cause a worksheet to disappear:

1. A person cleaning up files inadvertantly deletes the shared file.
2. A person browsing the server files changes the name of the file because
it conflicts with their file name or they believe it is a duplicate of their
file.

Sometimes the files can be found by searching with Windows Explorer and
sometimes they are gone forever as you originally knew them.

"BrianL_SF" wrote:

Hello All,

This is my first time posting in any Usernet group. We have an issue
at work where multiple worksheets would disappear in a shared Excel
file randomly. We are running Excel 2000 with about 10 users accessing

and update these four shared spreadsheets. Every few days or so, I
would get users complaining that two worksheets have disappeared. I
checked to make sure that they are not hidden and also they are unable
to delete the worksheets since we password-protected it. People would
have to unprotect the worksheet, then unshare it before they can
actually delete the worksheet.


Do you know if this is a bug in Excel 2000 or if there a fix for this?
We are running Office Service Pack 3. I searched all over Google and
others have experienced this problem, but have never found a resolution

to this.


Thanks for all your help.
Brian