Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've ticked 'preserve cell formatting on update', but if one of the columns doesn't have an entry then it disappears. Is there any way I can keep it from disappearing even if it's blank? I suspect not because of the nature of Pivot Tables, but it's worth asking.

I have 6 columns - 3 No's and 3 Yes's. I only need the Yes's to appear in the PT, so I select them, and it all works fine while there is something in the Yes column. However, when the soucre table doesn't have a Yes in it then the appropriate column disappears.

Any advice greatly appreciated.

Many thanks


share|improve this question
Not sure I understand the layout of your data. Can you provide a sample? – Jody Mar 26 '11 at 16:02

You must log in to answer this question.

Browse other questions tagged .