Forum Discussion
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 that or use any other Office 365 app for collaboration purposes with same convenience that coauthoring of online excel provides.
I know about sharepoint but they make us create a new file everytime we need to enter.
What we want is to have one common file that can continue to be edited for year long atleast with coauthoring from other departments.
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.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.
- size 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=
