Home |
Search |
Today's Posts |
#1
|
|||
|
|||
File size -
One of my colleague has been working on a pretty large file that initially 4
MB. The file contains 15 sheets and each sheets has around 400 rows and columns going up to "CC", almost all cells have formulas referencing other shhets. My colleague said that he did little modifications but the file went from 4MB to 6MB and ending up to 12BM. My question is : is there a way that determine if the size of the file is normal (eg. do not contain "ghost" data) based on the number of cells, formuals, formatiign.... Maybe an external tool ? Open.Repair ? |
#2
|
|||
|
|||
Hi stabilo
See http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl "stabilo" wrote in message ... One of my colleague has been working on a pretty large file that initially 4 MB. The file contains 15 sheets and each sheets has around 400 rows and columns going up to "CC", almost all cells have formulas referencing other shhets. My colleague said that he did little modifications but the file went from 4MB to 6MB and ending up to 12BM. My question is : is there a way that determine if the size of the file is normal (eg. do not contain "ghost" data) based on the number of cells, formuals, formatiign.... Maybe an external tool ? Open.Repair ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP blows up file size | Excel Worksheet Functions | |||
File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) |