Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File size increased dramatically | Excel Discussion (Misc queries) | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
What increased my file size from 2mb to 5mb in a week? | Excel Discussion (Misc queries) | |||
File size increased 7-fold! | Excel Discussion (Misc queries) | |||
Excel file size increased | Excel Discussion (Misc queries) |