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.

| 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.

| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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