View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank Canada Frank Canada is offline
external usenet poster
 
Posts: 1
Default 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.