View original (French)

Urgent issue with source data in pivot table

karen -  
 karen -
Hello,

I use pivot tables for my work service statistics. I'm not an expert...
I need to submit updated data by 5 PM, but I'm unable to use them anymore due to a source data problem... I urgently need your skills!!!

Thank you very much!

Karen

Configuration: Windows / Chrome 63.0.3239.84

2 réponses

Réponse 1 / 2
jordane45 Posted messages 30426 Registration date   Status Modérateur Last intervention   4 830
 
Hello,


source data issue..

What do you mean ???

Have you checked the source of the data?
Where do the data come from exactly? From another tab? From an external database?
Do the data still exist?

--
Best regards, 
Jordane
0
Réponse 2 / 2
karen
 
Hello Jordan, and thank you for this quick response!
I am using an Excel file with many Pivot Tables and associated charts based on a data sheet.
For some pivots, the operational date is set as row labels, and whereas before I had a report by month, now it displays all the operational dates and shows “cannot display the PivotTable report on an existing report” and then asks me to replace the content of the destination cells in another pivot????
I managed to "fix" the problem by changing the operational date field to months... it seems to accept it...
I can send you the file privately if you want because I am not a specialist at all!!!

Thank you.
0