Excel Deleting Tabs in Workbook

[Paul Brobst]

I have a large file (35MB) that is shared, contains about 25 tabs and is
linked to one external spreadsheet periodically when I save the file Excel is
deleting tabs. I have never had this happen before and i'm unsure what is
causing the tabs to disappear. I know it cannot be someone deleting the tabs
since it is a shared workbook and unless they unshare the file they cannot
delete. Also, I had the this happen while the speadsheet was saved to my
local drive on my laptop which was not connected to the internet. Any ideas?

 

[Barb Reinhardt]

Might the worksheets be hidden by another user?

 

[Paul Brobst]

Barb, Thanks for the reply, yes, we check for hidden tabs, we even saved it
and removed the share but the tabs were gone and the file size was smaller
then the base file (with sharing on). This has baffled every Excel user
here at work and we have some pretty good users.

Thanks,
Paul

 

[Barb Reinhardt]

Did you check for "VeryHidden"?

Go into the VBE (Alt F11)
You should see the VBA Project and the workbook name.
Expand the Microsoft Excel Objects
Are the sheets you're looking for listed there? If so, select the sheet
and view the properties. It may be set to XLSheetVeryHidden.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.