View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default File size MASSIVE but why?

I have a quite a detailed report (Workbook) that has many macro's within.
On one sheet i have Photo's placed by a Macro into certain cells and sized to suit.

What i have done is run a macro that CLEARS ALL data and ALL Photos from the WorkBook.
This is OK, but i have NOTICED that the WorkBook size is now 56.6MB is size.

Is Excel storing the Images within somehow, although they are deleted?
How can i clear this temporary memory to reduce the file size again?

Corey....