Are there hidden sheets in workbooks created via export from other software?

Hi Guys,
Today, I don't need a formula, code, formatting, or anything difficult. I'm just curious about how excel behaves if the workbook was created via an export from another software suite.

We use a supply chain management suite online and one of the handiest features is virtually every screen has an "export" button. The default is Excel 03. I needed to print some labels and the suite didn't offer that. So I exported the data set to excel. Then I fired up word and started learning to mail merge. When i chose my "data file" it showed me two tabs. One said "export data" which is the default when exporting to excel. But it showed another tab as well. I thought it was wierd because I didn't remember two tabs. I re-opened Excel and sure enough, one tab, "export data" was right you'd expect. And, just to make me scratch my head, in Word the data file shown in the wizard contained columns and data I had removed. By remove I mean Cntrl+(minus).

I've never seen this behavior and like to learn new stuff. So if anyone can toss me a pointer I'd sure appreciate it.

Thanks, Happy Sunday !

Excel doesn't behave in any way. What information is placed in the workbook is totally down to the external app.

It is possible that a sheet is 'Very Hidden'. This simply means there are no prompts to unhide it in the user interface. You need to go to the VBA Dev environment (Alt-F11) and view the Project Explorer to see these sheets. You can also set them Visible using the Sheet Properties dialogue.

Ok, that works for me. Now I can quit scratching my head. Thank You.