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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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:
  • 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 211 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 190

Last 30 days Overall leaderboard