Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file size makes no sense!
Hi All,
I have a workbook which contains 4 sheets, no macro modules, but a workbook_open event the code of which is simply Application.Calculate = xlManual. The maximum no of columns used is 11 and the maximum rows is approx 4000. 2 columns in 2 sheets contain if(iserror(vlookup type formulas for all 4000 rows. When l save the workbook 'as is' it is 16.6MB in size!!! Having exported each individual sheet the sum of the sheets is 3.7 MB There are no hidden or very hidden sheets. The 2 sheets containing the if(iserror type formulas are approx 1.5MB each Surely this cannot be right Can anybody shed any light on what is going on? How do l reduce the the file size to approx 3.7MB? Regards Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file size makes no sense!
On Jun 3, 3:10*pm, "michael.beckinsale"
wrote: Hi All, I have a workbook which contains 4 sheets, no macro modules, but a workbook_open event the code of which is simply Application.Calculate = xlManual. The maximum no of columns used is 11 and the maximum rows is approx 4000. 2 columns in 2 sheets contain if(iserror(vlookup type formulas for all 4000 rows. When l save the workbook 'as is' it is 16.6MB in size!!! Having exported each individual sheet the sum of the sheets is 3.7 MB There are no hidden or very hidden sheets. The 2 sheets containing the if(iserror type formulas are approx 1.5MB each Surely this cannot be right Can anybody shed any light on what is going on? How do l reduce the the file size to approx 3.7MB? Regards Michael HI michael U can do one thing delete all the blank rows form every file. you migh have copied data from another sheet using copy all and paste into your sheets just select all the blank rows and delete them , do this in every sheet , I belive the size of your file will be decreaze. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
file size makes no sense!
Check out this link...
http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "michael.beckinsale" wrote: Hi All, I have a workbook which contains 4 sheets, no macro modules, but a workbook_open event the code of which is simply Application.Calculate = xlManual. The maximum no of columns used is 11 and the maximum rows is approx 4000. 2 columns in 2 sheets contain if(iserror(vlookup type formulas for all 4000 rows. When l save the workbook 'as is' it is 16.6MB in size!!! Having exported each individual sheet the sum of the sheets is 3.7 MB There are no hidden or very hidden sheets. The 2 sheets containing the if(iserror type formulas are approx 1.5MB each Surely this cannot be right Can anybody shed any light on what is going on? How do l reduce the the file size to approx 3.7MB? Regards Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting PDF makes file huge | Excel Discussion (Misc queries) | |||
What makes a Large File in Excel? | Excel Discussion (Misc queries) | |||
Replace All makes me look for a file! | Excel Discussion (Misc queries) | |||
excel file when opened makes 30 copies | Excel Discussion (Misc queries) | |||
Arranging information so a chart makes sense | Charts and Charting in Excel |