Forum Discussion
BO1LER
Jun 04, 2020Copper Contributor
Excel stops working when Page edited
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.
- Ash365Brass ContributorIt'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