View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pp pp is offline
external usenet poster
 
Posts: 10
Default Saving Excel file w/o any data

Hi Folks

I have a excel file with VB code and Pivot table in it.
When the file loads the code gets executes and data gets populated in the
PIVOT Table

QUestion: When I save this excel file, is there any way I can save the file
w/o any data in it, just the VBCode and the PIVOT Table. The reason I say
this is , when the data gets loaded its size grows upto 27MB:)

Any help appreciated

Thanks
PP