Multiple Sheets Ceates Folder of Sheets & XML File?

  • Thread starter Thread starter J-Mac
  • Start date Start date
J

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

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

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!
 
Back
Top