Workbook protection impacts file size when compressing a spreadshe

F

Frank Canada

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro error when trying to open workbook 6
Userinterfaceonly 5
Enabling Macros message when NO macros in workbook 3
Auto compressing of images 4
Copy protection from one worksheet to another 1
Macros 2
workbook protection 3
changing password in Excel workbook 6

Top