Unknown Sheets in WB

[Brian.Crawford]

Excel 2007. Over time (and many [100's] Excel "Is not responding" anymore "the white screen of death") I seemed to have accumulated a few extra WS in my WB. These sheets are not viewable (cannot be UnHidden) and do not have there VeryHidden property set.

What is odd is that these "sheets" do not have the "sheet" icon in project explorer, instead they have the workbook icon.

Also, they are called "sheets" (10 & 16) in project explorer but when clicked on their "type" (ie name) in their properties window is "thisWorkbook" along with the real "thisWorkbook" (that looks and is normal, with code).

There is no code associated with these "things".
Suggestions on their source and how to get rid of them (can't remove or delete them)?

thanks
Brian

 

[ZVI]

Hi Brian,
At some Excel crashes the workbook can hold ghost sheet(s) in its VBProject, i.e. in vbaProject.bin part of file.
I can manually clean it up. Let me know via PM if you are ready to send me your workbook and I'll PM you my e-mail.
If so then please extract sensitive data from the sheets to copy it back on your side after fixing file structure.
Regards,
Vlad

 

[ZVI]

Brian, I’ve sent you my e-mail.

But you can also try to fix workbook by yourself as follows:

Method 1 – in Excel select all sheets (tabs) and copy it to the new workbook, then in VBE copy VBA code and save new workbook for the further usage.

Method 2 – save XLSM as XLSX with different name. Close XLSX and reload it. If the ghost sheets in VBE are disappeared then copy VBA code from XLSM and save workbook as XLSM.

Regards

 

[Brian.Crawford]

Thanks, I will give it a try later today/this evening and let you know how I do.