Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Excel file sizePosted by Lina Liu on August 10, 2001 12:02 PM
I have an Excel file that has multiple tabs.
Each tab represent one bank account information.
The user is keeping track of the Incoming/Outgoing fund activities and has a column that shows the running balance for each day. Not very fancy.
On Day 1, with 10 tabs , 6 months activities, the file size is about 2Meg.
On Day 2, user decided to add 2 more tabs to keep track of 2 more bank accounts. He copied the settings from one tab and created the new tabs. No data for the new tabs yet. But the file size increased to 6Meg.
Since this looks strange, we decided to delete the 2 new tabs and save the file. The size is still around 6Meg.
What would have caused this? Is there a way to compact an Excel file ? We are using Office 97 mainly, but the update might have been done on Office 2000. Is this a result of updating using different Excel versions ? Thanks.
Re: Excel file sizePosted by Cory on August 10, 2001 12:35 PM
Sounds like you already know what happened. If it was updated by the newer version of excel (which is a little more detailed and intensive), then this could very well be the cause of the sudden file increase. Have you tried resaving it using 97?
Ive had similar problems, but..Posted by Rob on August 10, 2001 2:10 PM
I've had large files, then tried to delete the new tabs, but the files stays the same size...only difference is, I've always been using office 2000. I have no idea what the problem is, but I solved it by making a new workbook.
Re: Excel file sizePosted by Paul on August 12, 2001 3:52 PM
It's the change from one format to another that does it. Have you got any pictures in the file that are not really needed. These can make a big difference in format differences between Excel 95/97/2000. Junk them if you can and watch that file shrink.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.