View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Adam is offline
external usenet poster
 
Posts: 287
Default 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.