Forum Discussion
Narwat350
Dec 15, 2023Copper Contributor
Large excel files not opening in online excel
My company uses coauthoring function of excel in browser. It was working fine until some days ago when it started showing messages that file size has exceeded 100MB. Is there any way to correct tha...
Patrick2788
Dec 15, 2023Silver Contributor
I recommend starting by opening one of the workbooks in the desktop version of Excel and run Inquire's Clean Excess Cell Formatting. It sounds like the workbook is bloated.
https://support.microsoft.com/en-au/office/clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738#:~:text=To%20remove%20the%20excess%20formatting%20in%20the%20current,changes%20to%20the%20sheets%20or%20No%20to%20cancel.
Narwat350
Dec 16, 2023Copper Contributor
Thanks for your prompt response but my excel doesnot show Inquire in my Com addins. Could you pls suggest any other method or tell me how can i install these addins in my excel.
- peiyezhuDec 16, 2023Bronze Contributorsize has exceeded 100MB.
You can delete extra formatting manually.
https://www.howtogeek.com/764717/how-to-clear-formatting-in-microsoft-excel/
Alternatively,using database also an option if too many rows in a worksheet.
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=