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