View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Huge Excel Document

Hi
maybe the following helps:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany


Jenny wrote:
Yesterday my Excel document was 1.5 MB and today it is 5.3
MB. All I did was add some VB code (maybe 50 lines) and a
few worksheets to it. The worksheets are general and do
not contain any graphics.

Does anyone know what could be causing the workbook to get
so huge and is there any automated clean up I can run to
remove unused code and such?

~Jenny