View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] JohnC@Raytheon.com is offline
external usenet poster
 
Posts: 25
Default Excel File Shrink

Pete, thanks for the response. no name ranges or shapes. I use Microsoft's
Excess Formatting Cleaner hopefully to clean up these things. John

"Pete_UK" wrote:

Do you have any pictures or shapes that you don't need in there? Any
named ranges which are no longer used?

Pete

On Jul 8, 12:22 am,
wrote:
I've got a 3 MB VBA file that has grown to 50 MB+. Any ideas on how to chop
it down?

Things tried already:
-Last cell issue resolved, including contexture fix.
-Temp files in Windows & Internet purged.

I've spent hours researching this on this site and others, but nothing seems
to workl

Thanks for any help,
John