Sheets not showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Mauricio,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top