refresh pivot table will cut all other columns

  • Thread starter Thread starter ewang1205
  • Start date Start date
E

ewang1205

I have a Excel with pivot table. I changed one column name from th
source and sheet, when I want to refresh the pivot sheet to see th
changed source column name, I got pretty much a blank sheet. Why???
Thanks
 
Excel keeps track of what data is what by the column headers and row labels,
so changing those will cause Excel to remove the renamed data from the data
set and not replace it. Better to leave the labels alone, unless you want
to re-create all your pivot tables.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing a pivot table 1
Referencing a pivot tables Grand Totals Column 1
Refresh order when refreshing all in a workbook 1
Macro for auto refresh 1
Cannot Open Pivot Table Source File 0
Pivot Table - Changes 5
Column limit for Pivot Table data source 1
One pivot table cannot overlap another pivot issue. 1

Back
Top