| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nulls in Pivot Tables
I have a couple of Pivot tables on the same page that are linked together.
Under the Pivots, I am referencing data from the pivot cells into detailed calculations below. My issue is, when there is not data in a column, the pivot automatically deletes the column and throws off all of my calculations below. I'm sure there is some VB code that I can write to prevent this, and have the Pivot include a null space, but I do not know how to do this. Any suggestions? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Any way to programmatically make pivot tables behave more like data tables? | Excel Programming | |||
| (Tom?) Pivot tables, code to refer to all pivot tables on template | Excel Programming | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
| Pivot tables-controlling user interaction with pivot tables | Excel Programming | |||
Linear Mode
