How do I stop Excel from saving my worksheet in multiple files?

[Guest]

I am using Excel 2002 Sp2 on Windows XP. I have a simple workbook with 3
separate worksheets. The worksheets contain no formulas, only text and
numbers. There are no links from one worksheet to any other. When I save
the file, I get a single file, say "ExcelTest.xls". Then I do some work one
some areas of the spreadsheets, and then do a subsequent save by clicking on
the disk icon. For some strange reason, the file is now saved as
"ExcelTest.xls" and there is a new directory called "ExcelTest_files" which
contains one separate xls file for each of the individual spreadsheets in my
workbook. I cannot determine what caused the file-save behavior to change,
nor can I find any options in Excel to turn this behavior off. Curiously, if
I load the spreadsheet and then do a Save-As with a new name, I will get a
single file once again. Somebody please tell me what is causing this strange
behavior, and how I can turn it off.

Thank you.

 

[Dave Peterson]

It sounds like you're saving as a web page (or something to do with HTML junk).

Do a File|SaveAs and verify that you're using
"microsoft excel workbook (*.xls)"