Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size mystery
1. I have a workbook with 42 sheets. Size: 3,8 mb
2. Then I have a copy with a diagram on each sheet. Size: 43,5 mb (approx. 1 mb per diagram). 3. Using a macro I copy the diagrams (diagrams only) to a new workbook. Size: 132,6 mb !!! If I copy the 42 diagrams manually, the size of the new workbook is only 24,5 mb. Can anyone explain this mystery? Any ideas as how to copy the diagrams automatically and keep the file size down to "normal"? Thanks, Eric Bentzen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size mystery
Hi Eric,
Maybe the code you use to do the copy does not replicate how you do it manually. Exactly what are these diagrams, 1mb / diag seems a lot. Post the code you use to do the copy. Regards, Peter T "Eric Bentzen" wrote in message .. . 1. I have a workbook with 42 sheets. Size: 3,8 mb 2. Then I have a copy with a diagram on each sheet. Size: 43,5 mb (approx. 1 mb per diagram). 3. Using a macro I copy the diagrams (diagrams only) to a new workbook. Size: 132,6 mb !!! If I copy the 42 diagrams manually, the size of the new workbook is only 24,5 mb. Can anyone explain this mystery? Any ideas as how to copy the diagrams automatically and keep the file size down to "normal"? Thanks, Eric Bentzen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |