Forum Discussion

Copper Contributor

Jul 05, 2023

Pivot Table Error When Try to Refresh

I am having trouble refreshing my pivot table data. Every time I go to data & click refresh all, it pulls up an error message: This is very frustrating, so any help would be greatly apprec...

excel

SergeiBaklan

Diamond Contributor

Jul 06, 2023

jbabineaux92

If staying on PivotTable to check on ribbon->PivotTable Analyze->Change Data Source, how many rows in shown here range?

jbabineaux92

Copper Contributor

Jul 10, 2023

SergeiBaklan

This is a snip of what it shows when I go the that:

SergeiBaklan
Diamond Contributor
Jul 10, 2023
jbabineaux92

So you have only one row in data set, but at least two are required (headers and data). Behaviour as expected, perhaps you need to change your data source.