Hi Jim

On file load excel file connects to SQL Source, and downloads the data into
virtual Pivot table and then loads the data on pivot table.

There is no worksheet which holds the data, it comes from DB

Hope this explains


Thanks
PP

"Jim Thomlinson" wrote:

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