Link to home
Start Free TrialLog in
Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel Pivot Table Refresh problem - when data is changed causes ?NAME error in table

HI Guys

Hope you can help

Ive got a spreadsheet which is linked to a pivot table for some monthly supply chain data

Its been working OK but this month Ive updated it for August but needed to change some cost values - when I did this and refreshed the pivot it goes blank with ?NAME in all the cells?

Ive tried to see if something is wrong but cannot find any issue except for the fact that the 1st August date in the Caluculated field list comes out as 1/08/20172 but in the list it is correct?

I have attached the file - the tab is Monthly Summary

If you could help I would be very grateful

Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jase Alexander


Thank you Rob - works perfect !
Glad to help.