Excel stops working when Page edited

%3CLINGO-SUB%20id%3D%22lingo-sub-1439158%22%20slang%3D%22en-US%22%3EExcel%20stops%20working%20when%20Page%20edited%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439158%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20book%20with%20a%20lot%20of%20sortby%20and%20lookup%20functions%2C%20among%20others.%20It%20opens%20fine%2C%20but%20on%20June%201%2C%20it%20began%20locking%20up%20any%20time%20I%20edit%20one%20specific%20table.%20I'll%20try%20to%20upload%20the%20file%20for%20inspection%2C%20if%20anyone%20can%20get%20it%20to%20work.%20I%20appreciate%20the%20help.%20I%20can't%20help%20thinking%20a%20function%20has%20been%20removed%20from%20my%20version%20somehow.%20The%20trouble%20is%20when%20editing%20the%20PM%20Accounts%20tab.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1439158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1439588%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stops%20working%20when%20Page%20edited%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439588%22%20slang%3D%22en-US%22%3EIt's%20probably%20locking%20up%20because%20of%20the%20amount%20of%20data%20in%20it.%20It%20locked%20when%20I%20tried%20to%20launch%20it%20on%20my%20PC%20so%20I%20tried%20Google%20spreadsheets%20instead%20and%20it%20opened%20up%20fine.%3CBR%20%2F%3EI%20would%20recommend%20using%20either%20Excel%20online%20from%20Microsoft%20or%20Google%20spreadsheet(Free)%20to%20edit%20this%20workbook%20since%20its%20such%20a%20resource%20hog%20on%20a%20computer.%20Editing%20it%20online%20will%20transfer%20all%20the%20processing%20to%20the%20SAAS%20app%20and%20it%20wont%20slow%20or%20lock%20your%20PC.%20I%20was%20able%20to%20edit%20the%20PM%20tab%20there%20as%20well.%3CBR%20%2F%3E%3CBR%20%2F%3EAsh%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447183%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stops%20working%20when%20Page%20edited%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447183%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368417%22%20target%3D%22_blank%22%3E%40Ash365%3C%2FA%3E%26nbsp%3B.%20I%20converted%20it%20to%20Google%20Sheets.%20Some%20of%20the%20functions%20needed%20to%20be%20changed%2C%20but%20it%20was%20too%20big%20for%20Excel%20online.%20Appreciate%20the%20guidance.%26nbsp%3B%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463462%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stops%20working%20when%20Page%20edited%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463462%22%20slang%3D%22en-US%22%3E%3CP%3EI%20seem%20to%20be%20forgotten%20halfway%20thru%20my%20problem%20solving.%20Haven't%20herad%20for%203%20or%204%20days.%20Please%20have%20someone%20help%20me%20today.%20I%20will%20be%20out%20of%20town%20tomorrow.%20thank%20you.%20Frank%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F688516%22%20target%3D%22_blank%22%3E%40BO1LER%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel book with a lot of sortby and lookup functions, among others. It opened fine before, but on June 1, it began locking up any time I edit one specific table or even select those cells. I'll try to upload the file for inspection, if anyone can get it to work. I appreciate the help. I can't help thinking a function has been removed from my version somehow. The trouble is when editing the PM Accounts tab.

Thank you.

 

EDIT: original attachment removed, as there's no longer a reason to share it. 

3 Replies
It's probably locking up because of the amount of data in it. It locked when I tried to launch it on my PC so I tried Google spreadsheets instead and it opened up fine.
I would recommend using either Excel online from Microsoft or Google spreadsheet(Free) to edit this workbook since its such a resource hog on a computer. Editing it online will transfer all the processing to the SAAS app and it wont slow or lock your PC. I was able to edit the PM tab there as well.

Ash

Thanks @Ash365 . I converted it to Google Sheets. Some of the functions needed to be changed, but it was too big for Excel online. Appreciate the guidance. 

Mike

I seem to be forgotten halfway thru my problem solving. Haven't herad for 3 or 4 days. Please have someone help me today. I will be out of town tomorrow. thank you. Frank@BO1LER