Use Compression when Saving Workbook
Set this indicator if your workbook includes a large amount of information and metadata and you want to reduce the space required by your workbook by compressing the data in the workbook when you save it.

You can use this option if, for example, you are working in formula mode and want to view the data in your result set without having to connect to the server (Provide Results Offline). To do this, you must first save the result set in the workbook. If you do not do this, the data is not available in the cells the next time you open the workbook; only the formulas are displayed.