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

E

Exceller

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!
 
M

marstinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel File Size 9
Excel file size too large 1
Power Point Sound File Size 2
Large File Size 3
Excel 2002 files up to 78% smaller after installing XP SP3. *What*the? 0
Formulas within list fail to update after sorting/filtering 0
Increase in the size of Excel Workbook. 1
Increase in the Size of the Excel WorkBook 1

Top