Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I attempt to refresh an Excel Pivot table (by right click .. Refresh), all of the Column Labels & Values fields disappear, leaving only Row Label fields and an empty Pivot Table. How can I keep Columns Labels and Values fields the same, avoiding the behaviour described above, and refresh only the data.

I've noted that this only seems to occur when I open a spreadsheet sent from another person, or if somebody opens up a spreadsheet I created with Pivot Table in it.

I'm using Excel 2007.

share|improve this question
    
What is your question? You want to know how to stop this behavior? It's best to be explicit, thanks. –  Shinrai Oct 22 '12 at 23:07
    
Yes, explicitly: how do i stop this behavior? –  Sky Oct 23 '12 at 14:33

1 Answer 1

I solved this myself after much trial/error-

The source table had Column Labels formatted as Dates for columns. (11/1/12 to represent Nov/12, 12/1/12 to represent Dec/12, etc.). However the Pivot Table Values/Column Labels were 'Nov/12', 'Dec/12', etc.

Changing the column names in the Source Data to match those in the Pivot Table ('Nov/12) fixed this behaviour.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.