Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.