Where is the pivot table getting it's data from? Is the data in a worksheet
or is this data coming from and external source such as from MS Access?
--
HTH...

Jim Thomlinson


"PP" wrote:

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