OneDrive File Issues

Fix Power Automate Excel Table Not Found After OneDrive File Replacement

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

Resolve a Power Automate flow that cannot overwrite a OneDrive workbook and then cannot find its Excel table.

Fix Power Automate Excel Table Not Found After OneDrive File Replacement
Product
Microsoft Power Automate, Excel Online, OneDrive, and SharePoint
Device & OS
not provided
Scenario
A flow reads an Excel table in OneDrive to update a SharePoint list, but the workbook must first be replaced or updated.
Observed behavior
The workbook cannot be overwritten, and a later flow action reports that the Excel table resource cannot be found.
Before you start

Identify the OneDrive workbook, its table name, and the flow actions that replace the file and read the table. Check the latest failed run for the exact error and the action where it occurred.

Solution 1Recommended

Check the OneDrive workbook and refresh the Excel table reference

Use these checks to investigate file locks and stale workbook or table references after a replacement.

1
Inspect the failed run

Open the flow in Power Automate, select the failed run under Run history, and expand the file and Excel actions to review their inputs and error messages.

2
Check for an open workbook

Close the workbook in Excel and Excel for the web, and ask other editors to close it. Run the flow again to see whether an active editing session was preventing the overwrite.

3
Verify the table in the replacement file

Open the replacement workbook from OneDrive in Excel. Select a cell in the data and check Table Design for the table name; if the data is not already a table, select it and use Insert > Table.

4
Reselect the file and table

In Power Automate, open the flow and select Edit. In the Excel action that reads the rows, reselect the OneDrive location, workbook, and table from the available fields, then save the flow.

5
Test the flow

Select Test in the flow editor and review the new run history. Confirm that the file action succeeds before checking whether the Excel action reads the table and updates the SharePoint list.

Check the OneDrive workbook and refresh the Excel table reference
Replacement can change references: Replacing a workbook or recreating its table can leave a flow pointing to an old file or table reference. Reselecting the current resources may help, but the overwrite error may require separate investigation.
Free Microsoft Office alternative

Edit Excel workbooks with WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format support for an easier move between office suites. It can help you edit spreadsheet data, but it does not fix Power Automate connector errors.

Edit spreadsheet data in WPS SpreadsheetsOpen and save Microsoft Excel XLSX filesUse a familiar interface for everyday office tasksWork with a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why can Power Automate no longer find the Excel table?

The flow may still reference a previous workbook or table after replacement. Open the Excel action in the flow editor and reselect the current file and table, then test the flow.

How do I check whether my Excel data is a table?

Open the workbook in Excel and select a cell in the data. If it is an Excel table, the Table Design tab shows its table name. Otherwise, select the data and choose Insert > Table.

Could an open workbook prevent the file from being overwritten?

An active editing session can contribute to file locking. Close the workbook in Excel and Excel for the web, ask other editors to close it, and test the file action again.

Where can I get help if the flow still fails?

Post in the Microsoft Power Automate Community with the failed action names and error messages from Run history. Include how the OneDrive workbook is replaced, but remove sensitive information.