Help Needed, Warning, upon opening the sheet.

[RaynoM1989]

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?

Regards

Rayno

[#2 · Accepted solution]

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.

[#3]

@Sergei Baklan 

Thanks for the feedback, i will try this and let you know if it works.

Regards

Rayno