ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Workbook protection impacts file size when compressing a spreadshe (https://www.excelbanter.com/excel-worksheet-functions/245748-workbook-protection-impacts-file-size-when-compressing-spreadshe.html)

Frank Canada

Workbook protection impacts file size when compressing a spreadshe
 
I noticed that when I use a password to protect a Workbook there is an impact
to the capabilities of compressing it afterwards. More specifically, I have
a spreadsheet of over 200MB that I can compress to about 40MB when I do not
the feature workbook protection. When I put a password to protect the
workbook, the compress size is about 191MB. This is not good. Any way to
resolve this issue.


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com