A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel file size increased 3 times after saving!!!!



 
 
Thread Tools Display Modes
  #1  
Old March 12th, 2010, 12:57 PM posted to microsoft.public.excel.worksheet.functions
Exceller
external usenet poster
 
Posts: 20
Default Excel file size increased 3 times after saving!!!!

Hi all,

I have a very strange situation with my Excel workbook. I created Excel
workbook with conditional formulas (no other formulas) which total size is 3
Mb. After I put simple data for calculation and saved the workbook the size
increased to 10Mb! The data itself is just about 70Kb. I use Excel 2002 at
work. I should put this workbook on our company server, but our network is
not very good and people can't open it because of the 10MB.

I have never seen this before!
Can somebody help please?

Thank you in advance!
  #2  
Old March 13th, 2010, 04:09 PM posted to microsoft.public.excel.worksheet.functions
marstinson
external usenet poster
 
Posts: 1
Default Excel file size increased 3 times after saving!!!!

I don't claim to be an expert on Excel by any long stretch of the
imagination, but the first thing that came to my mind was that perhaps
change-tracking is turned on. This would cause Excel to save each change to
the original workbook in the tracking history, which would dramatically
increase the size of the file if you entered a lot of data. Justathot.
--
We are all slaves to our history. It is only by understanding history that
we can break those chains.


"Exceller" wrote:

Hi all,

I have a very strange situation with my Excel workbook. I created Excel
workbook with conditional formulas (no other formulas) which total size is 3
Mb. After I put simple data for calculation and saved the workbook the size
increased to 10Mb! The data itself is just about 70Kb. I use Excel 2002 at
work. I should put this workbook on our company server, but our network is
not very good and people can't open it because of the 10MB.

I have never seen this before!
Can somebody help please?

Thank you in advance!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.