Some of our clients use Excel Workbook to collaborate in SharePoint 2016 on-prem. One workbook had 9 sheets in it and the total size was 6 MB.
Later, a team member copied a sheet into it from another workbook and suddenly file size increased to 80MB. After that, it started opening super slow for all users and we started receiving complaints about it.
After looking at the document that why the size has increased that much we found-
Later, a team member copied a sheet into it from another workbook and suddenly file size increased to 80MB. After that, it started opening super slow for all users and we started receiving complaints about it.
After looking at the document that why the size has increased that much we found-
- Use of different colors all over new sheet.
- Some cells have some comments in them.
- Data was not a lot. (Confusing!!)
- There is no formula used in sheet. (which is not the cause of increased size.)
Solution:
I saved the workbook in Excel Binary Workbook .xlsb from .xlsx.
File size reduced to 10 MB.
No comments:
Post a Comment