SharePoint Document Issues

Fix Power Automate Cannot Update Excel File in SharePoint

Nimra Malik Sep 30, 2026 869 views

Question details

Users need to resolve an issue where a Power Automate flow fails to update an Excel workbook stored in SharePoint.

How to Fix Power Automate Cannot Update Excel File in SharePoint

Product: Power Automate
Device & OS: not provided
Scenario: Running an automated flow in Power Automate to modify or add rows to an Excel spreadsheet located in a SharePoint document library.
Observed behavior: The Power Automate flow fails to execute the update step, often returning an error indicating the file is locked for editing or an older Excel version is in use.

Before you start

Ensure you have the necessary edit permissions for the target SharePoint site and verify that the data in your Excel file is formatted as a formal Table, which is strictly required by Power Automate.

Solution 1Recommended

Resolve File Lock and Concurrency Issues

The most common reason for this failure is that the Excel file is locked by an active user session or a previous flow run that has not fully finished.

SharePoint places a temporary lock on Office files when they are opened to prevent conflicting edits. If an automation flow attempts to write to the file during this time, it will fail.

Close active sessions

Verify that no team members currently have the target Excel workbook open in either the Excel desktop application or Excel for the Web.

Check out and check in

Navigate to the SharePoint document library, right-click the Excel file, select 'Check out', and then immediately 'Check in'. This can help clear residual background locks.

Adjust flow timing

In your Power Automate flow, consider adding a 'Delay' action (e.g., 30 to 60 seconds) right before the Excel update step to ensure that any preceding operations have fully released their locks.

Resolve File Lock and Concurrency Issues

File Size and Complexity: Extremely large Excel files with complex formulas can take longer for SharePoint to save and unlock, increasing the chance of Power Automate timeouts.

Solution 2

Seek Specialized Help from the Microsoft Community

If the file is definitely not locked and the flow still fails, there may be a deeper configuration issue or a temporary service outage requiring specialized Microsoft support.

Free Microsoft Office alternative

Manage Spreadsheets Seamlessly with WPS Office

If you are experiencing frequent synchronization or file-lock frustrations with Microsoft Office ecosystem, consider switching to WPS Office. It provides a lightweight, robust, and free alternative for managing all your daily spreadsheet tasks locally and securely.

1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install and launch: Run the installer to set up WPS Office on your computer, then launch the WPS Spreadsheets application.
3. Edit your files: Open your downloaded Excel spreadsheets directly in WPS to edit, format, and save them with full original compatibility.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight application that opens large files instantly without freezingFamiliar, user-friendly interface that requires zero learning curveCompletely free basic version with powerful data analysis tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate report my Excel file is locked?

A file lock typically occurs when a user has the workbook actively open in a browser or desktop application. It can also happen if a previous automation flow failed or was interrupted before it could release its background lock on the file.

Does Power Automate require a specific format for Excel data?

Yes. To update or add rows using Power Automate, your Excel data must be formatted as a formal Table. You can do this by selecting your data in Excel and navigating to Insert > Table.

Can I manually force an unlock on a SharePoint Excel file?

If you have Site Administrator privileges, you may be able to clear locks by forcing a check-in. Alternatively, asking all users to clear their browser cache and ensuring all Office web sessions are closed usually resolves lingering locks within 15 to 30 minutes.

Document & File Issues