starsky
05-10-2011, 07:59 AM
Hi,
I'm helping out someone with an annual report that is mostly a legacy document. It has multiple worksheets and charts. The problem is that, even when all data and charts have been delinked, the size of the workbook is massive (20+ mb). Copying any worksheet as a new workbook still produces a massive file of 18mb, even though just a single chart my appear on it. I have even replaced a chart with a picture and deleted the orignal chart and produced the same result.
Where is this size coming from?? I'm presuming Excel has always allocated a certain amount of space for this document that has been carried forward each year.
I'm helping out someone with an annual report that is mostly a legacy document. It has multiple worksheets and charts. The problem is that, even when all data and charts have been delinked, the size of the workbook is massive (20+ mb). Copying any worksheet as a new workbook still produces a massive file of 18mb, even though just a single chart my appear on it. I have even replaced a chart with a picture and deleted the orignal chart and produced the same result.
Where is this size coming from?? I'm presuming Excel has always allocated a certain amount of space for this document that has been carried forward each year.