This alone can reduce file size by 50%ĭo the following to ALL Worksheets. You can make this the default by going to Tools>Options/Transition and selecting Microsoft Excel Workbook from the Save Excel files as Combobox. Save as "Microsoft Excel Workbook (*.xls). After each step Save and check the File size by going to File>Properties/General If it has reduced the file size you shouldn't need to go any further!Īvoid saving as multiple versions. This means save a copy of your Workbook first. Below are some methods to overcome this problem, that should be performed in the order stated! Please note OzGrid accepts no responsibility for any loss of data. Unfortunately it is not too uncommon to have an Excel Workbook increase in file size for no apparent reason. Here is some important information on how to reduce file size.
0 Comments
Leave a Reply. |