web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not able to open expor...
Power Automate
Unanswered

Not able to open exported excel file in local

(0) ShareShare
ReportReport
Posted on by 2

Hi 

 

We are trying to export the data in .csv file which is in Sharepoint into .xls or .xlsx file format while sending them as an attachment in the email. We have used scheduled flow for this and were able to export and receive them by email. When we try to open both files(.xls, .xlsx) in google sheets we were able to see the data successfully. However, when we download and try to open the same files locally, we are getting the below-mentioned errors. We have Excel2013 in our local. Not able to know what is causing this issue. Whether this is any version-related/mismatch issue or file format issue. Kindly help us in this regard.

Thanks in advance.xls.pngxlsx.png

Categories:
I have the same question (0)
  • Verified answer
    Drakewilson Profile Picture
    17 on at

    1: Punctual Method (must repeat for each file)

    Open the file in Windows Explorer
    Right-click on the .XLS file and select Properties
    Check the Unblock option and then click Apply

     

    2: Change Trust Settings in Excel

    *** Warning All XLS files from the Internet will be able to be opened without verification ***

    Open Excel
    Go to Files>Options
    Click on the Trust Center
    Click on the Trust Center Settings button
    Disable (deselect) the “Enable Projected View for files originating from the Internet” option

     

    Regards,
    Drake

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard