$$Excel-Macros$$ Re: Code to remove cache after running pivot table

2009-07-25 Thread vivek agrawal
Hi Ravi... I am not easy with pivots but guess the following link might be helpful http://www.brainbell.com/tutorials/Excel_VBA/Size_Of_A_Finished_Pivot_Table.html Hope it Helps Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25

$$Excel-Macros$$ Re: Code to remove cache after running pivot table

2009-07-25 Thread Ravi Megharaj
Hi, Can someone share vba code to remove the Cache memory, when we run the pivot tables. Whenever i run the pivot tables the file size expands substantially. Thanks Ravi Megharaj --~--~-~--~~~---~--~~ ---