LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Excel 2007 file in 2003 creates very large file Jon Pearce Excel Discussion (Misc queries) 2 July 16th 09 07:20 PM
Can i recover my excel file after saving with new data? katieneedshelp! Excel Discussion (Misc queries) 1 August 11th 05 03:13 PM
saving dbf file without losing data govworker Excel Discussion (Misc queries) 0 February 7th 05 11:27 PM
Close file without saving data ExcelMonkey[_96_] Excel Programming 2 March 2nd 04 11:34 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"