Jase Alexander
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help.
ASKER