protected mode

bitshift 136 Reputation points
2020-11-27T13:49:47.26+00:00

I am looking at ways to automate via powershell grabbing some excel files from a customer web portal my team is working with. Out of 4 files I grab each time, each file (which is an older .xls format) must be saved as .xlsx, but 1 or two of the files (sometimes none) have a warning about protected mode when opened.

PROTECTED VIEW Office has detected a problem with this file. Editing may harm your computer. Click for more details.

Is this pretty much always the case with .xls files? Why some and not others that are also .xls?
link

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,635 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erin Ding-MSFT 4,456 Reputation points
    2020-11-30T03:27:31.057+00:00

    @bitshift

    As mentioned in the article you provided, the message always occurs with Excel 97-2003 files (.xls) files since .xls files often bring about some issues like compatibility issues which may be considered to pose a security risk by Office File Validation.
    And this message often occurs with .xls files that are detected a problem that may pose a security risk by Office File Validation.

    Note: We recommend you only do the following if the file's source and content are trusted by you.
    If you don't want it to open in Protected View, you could try to move the files to a trusted location.
    You could view the trusted locations in File>Options>Trust Center>Trust Center Settings>Trusted locations.
    43465-1.png

    You could also uncheck the options in File>Options>Trust Center>Trust Center Settings>Protected View.
    43563-2.png

    Regards,
    Erin


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments