Prev: Consolidating Data Between Worksheets with Duplicates Removed
Next: Help with SUMIF & AND function
From: Exceller on 12 Mar 2010 07:57
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!
From: marstinson on 13 Mar 2010 11:09
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!
 | 
Pages: 1
Prev: Consolidating Data Between Worksheets with Duplicates Removed
Next: Help with SUMIF & AND function