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

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.