We help IT Professionals succeed at work.

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

53 Views
Last Modified: 2018-09-13
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
Comment
Watch Question

Finance Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Jase AlexanderCompliance Manager

Author

Commented:
Thank you Rob - works perfect !
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Glad to help.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.