Pivot Table

[lrussellbrown]

Hi All,

I am wondering if it is possible to produce a Pivot Table where I can fix the Column Headings - so that even if there are no values to return for a certain column, the pivot table will show that column heading and no values going down the rows.

This is so that I can run a macro of the pivot table without changing its dimensions as the values in the pivot table change from week to week.

Thanks,
Lee

[Carim]

Hi,

You can "cheat" with blanks ...

HTH
Carim