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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies