SOLVED
Home

Help Needed, Warning, upon opening the sheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-369259%22%20slang%3D%22en-US%22%3EHelp%20Needed%2C%20Warning%2C%20upon%20opening%20the%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369259%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%20All%2C%20hope%20you%20are%20well%20this%20morning.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20require%20some%20assistance%20with%20an%20Excel%20sheet%2C%20when%20i%20open%20up%20the%20excel%20sheet%20i%20receive%20the%20following%20warning%20message%20(Please%20see%20attached).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20googled%20the%20error%20but%20the%20fix%20provided%20to%20go%20to%20File%20%26gt%3B%20Options%20%26gt%3B%20Advanced%20and%20the%20deselect%20the%20%22Alert%20before%20overwriting%20cells%22%20tick%20box%20but%20it%20did%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sheet%20consists%20of%202%20Pivot%20and%20Graph%20sheet%20and%20one%20Data%20sheet%20both%20the%20Pivots%2FGraph%20sheets%20read%20from.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20assist%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERayno%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20831px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89140i4BE9DE6424CFC40F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Sheet%20Layout.PNG%22%20title%3D%22Sheet%20Layout.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20855px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89141iE90C163214E61537%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Warning.PNG%22%20title%3D%22Warning.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369259%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EError%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEXCEL%20GRAPH%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369878%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%2C%20Warning%2C%20upon%20opening%20the%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369878%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20feedback%2C%20i%20will%20try%20this%20and%20let%20you%20know%20if%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERayno%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369428%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%2C%20Warning%2C%20upon%20opening%20the%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369428%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20looks%20like%20you%20have%20not%20enough%20room%20for%20one%20of%20the%20Pivot%20Table%20in%20Overall%20sheet%2C%20another%20data%20(pivot%20table%2C%20whatever)%20is%20close%20to%20it.%20If%20so%20try%20to%20add%20more%20space%20before%20refreshing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
RaynoM1989
New Contributor

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

 

RaynoSheet Layout.PNGWarning.PNG

 

2 Replies
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.

@Sergei Baklan 

 

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

 

Regards

 

Rayno