Refreshing Pivot Table clears Values and Column Labels fields

0

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.

Sky

Posted 2012-10-22T22:24:04.273

Reputation: 11

What is your question? You want to know how to stop this behavior? It's best to be explicit, thanks. – Shinrai – 2012-10-22T23:07:01.760

Yes, explicitly: how do i stop this behavior? – Sky – 2012-10-23T14:33:19.880

Answers

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.

Sky

Posted 2012-10-22T22:24:04.273

Reputation: 11

Asked: 2012-10-22T22:24:04.273

Viewed: 13 940 times

Active: 2019-04-03T22:09:45.347