Re: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

2011-08-29 Thread XLS S
** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma > *Sent:* Monday, August 29, 2011 2:02 PM > > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Pivot table to remain intact - even i

RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

2011-08-29 Thread Amit Desai (MERU)
Excel-Macros$$ Pivot table to remain intact - even if data table is removed Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table wil

RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

2011-08-29 Thread Rajan_Verma
Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table will not effect if Data Table is Removed .. From: excel-macros@googlegroups.com [mai