Sheets not showing

M

Mauricio Silva

Hi there,

I have an Excel file that comes from a client and I have to import into my
MS Access database. The spreadsheet shows 5 sheets on it with simples data
and only one picture on the 5th sheet, according to the menu, there is
nothing hidden.

These are my sheets:
- Legend
- Studio Usage
- Studio Usage Calc background
- Summary
- Price Assembly

When I open the file thru Access and try to read it, it says that there are
10 sheets on the file, the 5 above and 5 more:

- March chargeable services
- no charge services
- Sheet2
- Sheet3
- Sheet4

Thru Access I can read them, write on them, do what ever I want but not thru
Excel. The funny part is... if I try to create new sheets, the first one
comes as Sheet1 and the second as Sheet5 as the Excel knew they are there.

Is there a way to make them appear?
Or maybe delete them?
Is this a bug?

Thanks
Mauricio Silva
 
C

cereh

Mauricio Silva said:
Hi there,

I have an Excel file that comes from a client and I have to import into my
MS Access database. The spreadsheet shows 5 sheets on it with simples data
and only one picture on the 5th sheet, according to the menu, there is
nothing hidden.

These are my sheets:
- Legend
- Studio Usage
- Studio Usage Calc background
- Summary
- Price Assembly

When I open the file thru Access and try to read it, it says that there are
10 sheets on the file, the 5 above and 5 more:

- March chargeable services
- no charge services
- Sheet2
- Sheet3
- Sheet4

Thru Access I can read them, write on them, do what ever I want but not thru
Excel. The funny part is... if I try to create new sheets, the first one
comes as Sheet1 and the second as Sheet5 as the Excel knew they are there.

Is there a way to make them appear?
Or maybe delete them?
Is this a bug?

Thanks
Mauricio Silva
Click to expand...

Mauricio,

In Excel, if you go to Format/Sheet/Unhide, the missing sheets may show, and
you then have the option to unhide them.
 
Top