Bug problem in excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1455960%22%20slang%3D%22en-US%22%3ERe%3A%20Bug%20problem%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695907%22%20target%3D%22_blank%22%3E%40Acssio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20don't%20you%20delete%20the%20objects%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456350%22%20slang%3D%22en-US%22%3ERe%3A%20Bug%20problem%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20not%20possible.%20The%20spreadsheet%20hangs%20completely.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456457%22%20slang%3D%22en-US%22%3ERe%3A%20Bug%20problem%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695907%22%20target%3D%22_blank%22%3E%40Acssio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESet%20calculation%20mode%20to%20manual%20before%20deleting%20the%20objects.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456490%22%20slang%3D%22en-US%22%3ERe%3A%20Bug%20problem%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456490%22%20slang%3D%22en-US%22%3E%3CP%3ESolution%20already%20tried.%20The%20error%20continues%20and%20the%20spreadsheet%20goes%20into%20bug.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455411%22%20slang%3D%22en-US%22%3EBug%20problem%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455411%22%20slang%3D%22en-US%22%3E%3CP%3EApparently%20the%20problem%20came%20after%20a%20ctrl%20%2B%20c%20from%20an%20external%20file%20that%20brings%20other%20objects%20with%20it%20into%20the%20excel%20spreadsheet.%26nbsp%3BMany%20objects%20are%20apparently%20attached%20to%20the%20spreadsheet.%20However%2C%20when%20trying%20to%20exclude%20the%20spreadsheet%20it%20crashes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20consists%20in%20the%20complete%20blocking%20of%20the%20worksheet%20for%20most%20of%20the%20time%2C%20it%20is%20not%20possible%20to%20perform%20the%20routines%20or%20when%20it%20is%20possible%20it%20is%20only%20extremely%20slow%20and%20slow.%3C%2FP%3E%3CP%3ESeveral%20solutions%20have%20been%20tried.%20First%20it%20was%20tried%20to%20locate%20the%20objects%20possibly%20foreign%20to%20the%20spreadsheet%20by%20the%20tab%20locate%20objects%2C%20then%20the%20quick%20repair%20of%20excel%20was%20attempted%2C%20and%20then%20the%20complete%20repair%20on%20the%20internet%20of%20the%20installed%20excel%20was%20attempted.%20Then%20it%20was%20attempted%20to%20disable%20supplements%20and%20graphics%20acceleration%20without%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInterestingly%2C%20in%20the%2022%20spreadsheets%20in%20the%20file%2C%20only%20one%20of%20them%20V1%20behaves%20alternating%20between%20slow%20or%20error%20behavior.%26nbsp%3B%20In%20the%20attached%20files%20the%20chaining%20of%20the%20problem%20is%20very%20detailed%20and%20visualized.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1455411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Apparently the problem came after a ctrl + c from an external file that brings other objects with it into the excel spreadsheet. Many objects are apparently attached to the spreadsheet. However, when trying to exclude the spreadsheet it crashes.

 

The problem consists in the complete blocking of the worksheet for most of the time, it is not possible to perform the routines or when it is possible it is only extremely slow and slow.

Several solutions have been tried. First it was tried to locate the objects possibly foreign to the spreadsheet by the tab locate objects, then the quick repair of excel was attempted, and then the complete repair on the internet of the installed excel was attempted. Then it was attempted to disable supplements and graphics acceleration without success.

 

Interestingly, in the 22 spreadsheets in the file, only one of them V1 behaves alternating between slow or error behavior.  In the attached files the chaining of the problem is very detailed and visualized.

4 Replies
Highlighted

@Acssio 

Why don't you delete the objects?

 

Highlighted

@Detlef Lewin 

 

It's not possible. The spreadsheet hangs completely.

Highlighted

@Acssio 

Set calculation mode to manual before deleting the objects.

 

Highlighted

Solution already tried. The error continues and the spreadsheet goes into bug.@Detlef Lewin