Forum Discussion

freder1ck's avatar
freder1ck
Icon for Kudo Kingpin rankKudo Kingpin
5 years ago
Solved

Excel Error: The file couldn't open in Protected View.

Anyone know of changes in Office 365, Excel (we're on the semi-annual channel, so we updated in Jan) that would cause this error to come up more often? It comes up when they export to Excel, but I ca...
Need Help
  • collinq's avatar
    collinq
    5 years ago

    Hi freder1ck ,

     

    I believe that you should ask this question in the Excel support group as this is the Power BI support.

collinq's avatar
collinq
Icon for Super User rankSuper User
5 years ago

Hi freder1ck ,

 

I believe that you should ask this question in the Excel support group as this is the Power BI support.

freder1ck's avatar
freder1ck
Icon for Kudo Kingpin rankKudo Kingpin
5 years ago

collinq:  
Yep, I've done that also. However, because this is ONLY happening with Excel export from Power BI and not any other sources, I thought it was worth a shot here as well. 

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    5 years ago

    Hey freder1ck .

     

    So, you are using Power BI?  In reading your original post I was assuming that this was an Excel only thing.  Are you saying that in Power BI, when the user uses "Export to Excel" they are getting a Protected View excel sheet?  As in, Password Protected or just the "Enable Editing" option on the top of the Excel form?

    • freder1ck's avatar
      freder1ck
      Icon for Kudo Kingpin rankKudo Kingpin
      5 years ago

      Yes, I see now that I did not say Power BI in my post. I did post it to the Power BI community and I categorized it under Power BI Service. I also referenced the Power BI Service functionality of export to Excel.

      So, it's not the bar at the top. That bar says: PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. [Enable Editing]. No this message says: The file coundn't be opened in Protected View. 

      If you haven't seen this error from Power BI export to Excel, that's cool. I never see it personally. I was checking to see if others had run into this before.