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

Thanks
J
UK-Supply-Chain-New-KPI-2016-2017.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rob Henson

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Jase Alexander

Thank you Rob - works perfect !
Rob Henson

Glad to help.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy