Excel 2010 + Multipe Sheets / Workbooks in VBE

[Rusty]

Hi,

I tired searching on this, but was struggling with terms... 'sheets', 'workbooks', 'objects' and 'VBE' are obviously not awesome search terms.

Basically I have multiple workbooks that were created in Excel 2003

When these have been used/converted in Excel 2010 (generally as xlsm's) they are displaying some anomalies in the VBE.

A workbook that has seven (7) viewable sheets in it, when viewed in the VBE has more then 20, such as:

Sheet1 <-- Green Xl symbol
Sheet10 <-- Green Xl symbol
Sheet101 <-- Green Xl symbol
Sheet1011 (AO) <-- Grid symbol, So this appears to be the actual worksheet

Likewise, I have:

ThisWorkbook
ThisWorkbook1
ThisWorkbook2

All have Green XL symbols.

Is this normal behaviour?

Could it cause performance issues?

Should I (and can I) get rid of them? And if so, how?

Thanks

 

[Rusty]

Hopefully this explains a bit better what I mean:



The actual workbook in question has 9 viewable sheets, and 3 hidden ones.

Anyone have any ideas?

 

[RoryA]

Can you post a file somewhere (eg box.net) without any data so we can check out the structure? My first thought is a corrupt file but I'd like to just check it's not something obscure like old excel 5 modules.

 

[Rusty]

Can you post a file somewhere (eg box.net) without any data so we can check out the structure? My first thought is a corrupt file but I'd like to just check it's not something obscure like old excel 5 modules.

I'll see what I can do. I'll have to strip the file of some information first given it's contents (sensitive information) or create a new test one.

I *think* the problem is being caused by an Excel add-in that is creating the additional sheets as temporary/cache sheets and not removing them afterwards.

 

[RoryA]

Maybe, but then they ought to have a tab name, which they don't appear to, and you should only ever have one Thisworkbook object!
Note: we don't need any data, just the workbook structure.