how to save several sheets in one workbook in

Microsoft Office excel 2007 home & stude...
August 3, 2010 at 11:17:35
Specs: Windows Vista, HP/125
I need to create and save 5 worksheets in one workbook. Every time I create the workbook and save it to a thumb drive and pull it up later everything is gone except the first worksheet I made. What am I doing wrong?

See More: how to save several sheets in one workbook in

Report •

#1
August 3, 2010 at 11:35:28
It's really hard to tell from here, but there is no reason that the other 4 sheets are not being saved.

Are you getting any warning about the file format only allowing a single sheets e.g. CSV?

A long shot is a Before_Save macro that deletes all but 1 sheet prior to the Save.


Report •

#2
August 3, 2010 at 11:53:13
Thank you. There is no warning and no macro. I just can't figure this one out. Shouldn't the pages pop up when I click the sheet tabs? This is not happening. The files are on the status bar and when I click on that the worksheets pop up on sheet one.

Report •

#3
August 3, 2010 at 12:39:05
Now you've confused me.

First you said:

...and pull it up later everything is gone except the first worksheet I made

Now you're saying:

Shouldn't the pages pop up when I click the sheet tabs?

If you have sheet tabs, then the sheets exist.

I think you need to explain this a little better.


Report •
Related Solutions


Ask Question