Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

One of the employees at my company is trying to publish some Excel files to our website (employee login only). The spreadsheet is rather large (12 columns wide), but there are no plans to convert it to dead-tree format; it's intended to stay digital. As such, the page layout is set to custom size landscape. When the spreadsheet is downloaded from our website, Excel opens it in protected view, which is expected since it's coming from a website. However, the protected view mode seems to be ignoring any page formatting, rendering it on 8.5x11 protrait pages, only allowing ~4 columns per page, and splitting it onto several horizontal pages.

I know that protected view is supposed to stop scripts etc from infecting computers, but is there any way to allow page formatting to be correctly displayed in protected view? I won't have access to every computer the file will be opened on, so default MS Office settings on the client-end would be preferred.

share|improve this question
    
Maybe print to PDF? –  Kev Mar 25 '13 at 14:33
add comment

1 Answer

I had a similar issue at my company. I needed Excel to open files without protected view so the macros would run to enable the interface, and protected view confused the users so they could not get the application to run.

Excel will not open files in protected view if they are from a trusted location. The best way to do this in an organization is through your domain's Group Policy. If I remember correctly, I needed to make two changes in group policy: 1) set your website as a trusted site in GP > Computer Configuration > Administrative Tools > Windows Components > Internet Explorer > Internet Control Panel > Security > Site to Zone assignment; and 2) you should set the network location the Excel files are being shared from as a trusted location for Microsoft Office using Office Group Policy Administrative Templates, which must be installed and configured in your domain.

You can also use Office GP Admin Templates to disable protected view entirely, but I would not advise it.

It's a lot of work to circumvent these measures that Microsoft has put in place to protect us from malicious code, but alas, such is the age we live in.

share|improve this answer
    
If it were me, I would publish it as a Google doc spreadsheet and put the link on your website. –  Baodad Apr 16 '13 at 21:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.