Re: $$Excel-Macros$$ Forcing pivot table to not resize (change number of columns or rows)

Dear Luc, Not sure about OLAP pivots, but you can try below link:- http://richardlees.blogspot.com/2009/10/excel-2007-olap-pivottable-tips.html Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On

Re: $$Excel-Macros$$ Forcing pivot table to not resize (change number of columns or rows)

Thanks, turns out I am using an OLAP pivot table, and as such it does not work. Any idea how to get around this for OLAP table? Thanks, Luc. On Nov 7, 10:44 am, Dilip Pandey wrote: > Hi Luc, > > Two options:- > 1) Choose complete columns in the data range for Pivot table e.g. (A1:H88 > should be

$$Excel-Macros$$ Forcing pivot table to not resize (change number of columns or rows)

I created a pivot table, for some selection, it will display a certain number of rows and columns. However it will resize itself automatically (i.e. will not display empty columns). This is quite annoying as I have formulas referencing the pivot table. Is there a way to force the pivot table to