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

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .