Good Morning All, hope you are well this morning.
I require some assistance with an Excel sheet, when i open up the excel sheet i receive the following warning message (Please see attached).
I have googled the error but the fix provided to go to File > Options > Advanced and the deselect the "Alert before overwriting cells" tick box but it did not work.
The sheet consists of 2 Pivot and Graph sheet and one Data sheet both the Pivots/Graph sheets read from.
Can you please assist?
View best response
It looks like you have not enough room for one of the Pivot Table in Overall sheet, another data (pivot table, whatever) is close to it. If so try to add more space before refreshing.
Thanks for the feedback, i will try this and let you know if it works.