Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Multiple Sheets Ceates Folder of Sheets & XML File?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J-Mac - 27 Jul 2006 05:29 GMT
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.

--
J-Mac
Arvi Laanemets - 27 Jul 2006 06:11 GMT
Hi

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

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

> Since installing MS Office 2003 last year I have noticed different
> behavior with working on multiple sheets.
[quoted text clipped - 32 lines]
> --
> J-Mac
J-Mac - 27 Jul 2006 07:53 GMT
>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!

--
J-Mac

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.