Multiple Sheets Ceates Folder of Sheets & XML File?

[J-Mac]

Since installing MS Office 2003 last year I have noticed different
behavior with working on multiple sheets.

First, every new sheet I open or create causes a new instance of Excel
to open. Standard Excel 2003 behavior? Or do I have something
configured incorrectly?

Next, I worked on an existing workbook named '200501.xls' yesterday.
While adding data to that workbook I created 11 additional worksheets,
renamed the tabs and saved it with the same filename.

Tonight I looked at that file in Windows Explorer and saw that it is
only 13 kb in disk size. I knew that could not be correct. Then I
noticed a folder there in that subdirectory that I had not actively
created, named '200501_files'. It contains 12 workbooks named
Sheet001.htm, Sheet002.htm, etc. There is also a file named
'stylesheet.css' and one named 'filelist.xml'. I realized that the
Sheet files represent the data for the worksheet tabs I created in
'200501.xls'.

Which means that as long as I want the original Excel file to stay
intact, I must keep this folder as it contains all the data for that
workbook.

Why did Excel create the sheet in this fashion? All previous versions
I have used did not add worksheets in this manner. All used to stay
in the base XLS file; CSS stylsheets and XML files were never required
in the past.

Again, is my Excel version configured incorrectly? Or is this just
how Excell handles all multi-worksheet workbooks now?

Thanks for any assistance with this.

 

[Arvi Laanemets]

Hi

You did Save As to Web Page. I'm not sure you can revert this.

 

[J-Mac]

Hi

You did Save As to Web Page. I'm not sure you can revert this.

Dang!! You're right, of course. What was I thinking?

Wonder how that was selected, as I didn't even realize that you could
save Excel sheets as web pages. I probably opened a file that was
configured that way and then that extension stayed as the default the
next time I opened Excel.

BTW, it saved fine as a workbook once I read your post and tried that.

Thanks for waking me up, Arvi - I needed that!