Sheets disappeared after saving

[cso]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I transferred a .XLS file from a PC to my mac. I added a new sheet and have been working on it since. However, I opened it last night to find that only the last sheet shows up and the first one disappeared. I don't understand why. I have been encountering saving problems already. I always like the Save button before exiting, but excel still asks me if I want to save my changes when no changes have been made. When I click "Save As" it suggests I save my file as Tab delimited. Could this be the problem?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I transferred a .XLS file from a PC to my mac. I added a new sheet and have
been working on it since. However, I opened it last night to find that only
the last sheet shows up and the first one disappeared. I don't understand
why. I have been encountering saving problems already. I always like the Save
button before exiting, but excel still asks me if I want to save my changes
when no changes have been made. When I click "Save As" it suggests I save my
file as Tab delimited. Could this be the problem?

It certainly could- text files are only saved as the data in a single
sheet. What is the default file type you have set in your preferences?

 

[cso]

What is tab delimited? How do I find out what my default file type is? My file is saved as .XLS

 

[CyberTaz]

Have a look in Excel> Preferences> Compatibility under Transition. Open the
Save files in this format: list & choose Excel Workbook (.xlsx) or Excel
97-2004 Workbook (.xls).

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[cso]

Hm, it is set to that already. I think it just might have been the file. Thanks!