topic Re: Excel exports ".xls" disable protected mode in SAS Enterprise Guide

Excel exports ".xls" disable protected mode

isek — Fri, 06 Sep 2019 08:37:57 GMT

Hello,
After executing SEG projects, we get excel ".xls" exports that are in protected mode. Has anyone ever encountered this problem or would have an idea of a solution?

I want to disable protected mode for all exports.

Thank you so much.

Re: Excel exports ".xls" disable protected mode

JosvanderVelden — Fri, 06 Sep 2019 09:17:23 GMT

Have you tried setting the options in excel that disable protected mode/view. File --> Options --> Trust Center --> Protected View & File --> Options --> Trust Center --> File Block Settings. I don't know if that can resolve the issue, but it might.

Re: Excel exports ".xls" disable protected mode

isek — Fri, 06 Sep 2019 09:44:52 GMT

Thanks for your reply JosvanderVelden. I already tried but with each new export the rule disappears and the file goes into protected mode, I wondered if something could be done on SEG.

Re: Excel exports ".xls" disable protected mode

JosvanderVelden — Fri, 06 Sep 2019 09:57:34 GMT

Protected View is a feature of microsoft office. I don't think it can be influenced through manipulation with SEG. Maybe if you export to .xlsx the behaviour is different?