'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Power Query File In Use Error on OneDrive
Question details
The user encounters a 'file is in use by another process' error when trying to refresh Power Query reports and PivotTables in an Excel workbook synced to OneDrive or SharePoint.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- Windows 11
- Scenario
- Refreshing a workbook that contains self-referencing Power Queries while background cloud synchronization is active.
- Observed behavior
- Excel reports that the file is being used by another process, which blocks the Power Query data refresh from completing successfully.
Ensure you have saved your current progress and verify the synchronization status of your OneDrive app before attempting to change sync settings or file locations.
Pause OneDrive Synchronization During Data Refresh
Temporarily halting the cloud sync process prevents the OneDrive service from locking the file while Excel's Power Query attempts to read and refresh the internal data.
This error is primarily caused by a conflict between a self-referencing query (a query that reads data from the same Excel file) and the cloud sync service attempting to upload the file simultaneously.
Click the OneDrive cloud icon located in the Windows system tray (bottom-right corner of your taskbar).
Click on the 'Help & Settings' gear icon, select 'Pause syncing', and choose '2 hours' from the dropdown menu.
Return to your Excel workbook, navigate to the 'Data' tab, and click 'Refresh All' to update your Power Query and PivotTables without conflicts.
Once the refresh is complete and the file is saved, open OneDrive again and click 'Resume syncing' to upload your updated workbook to the cloud.
Test the Workbook in a Local Directory
Moving the file outside of a synced folder determines if the issue is strictly isolated to OneDrive/SharePoint synchronization.
Open a Microsoft Support Request
Since this is a known product bug related to self-referencing queries and cloud synchronization, submitting a support ticket may be necessary for corporate environments to receive a lasting workaround.
Try WPS Office for Seamless Spreadsheet Management
Since this Power Query synchronization issue stems from deep Microsoft Excel and OneDrive process conflicts, consider using WPS Office as a free, lightweight, and easy-to-use alternative. It offers excellent compatibility with Microsoft formats and provides a smooth, reliable experience for your daily spreadsheet tasks.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your Windows device.
- 2. Install and Launch: Follow the quick installation wizard, then open WPS Spreadsheets.
- 3. Manage your Data: Open your existing .xlsx workbooks securely in WPS Office to analyze and process your data efficiently.
Frequently Asked Questions
Why does Excel say my file is in use during a Power Query refresh?
This error occurs when a Power Query reads data from the same workbook it is housed in (self-referencing), while a cloud service like OneDrive or SharePoint attempts to sync the file in the background, creating a file lock conflict.
Can I permanently fix this without pausing OneDrive?
A common structural workaround is to separate your data. Keep your raw source data in one workbook and your Power Query reports in a different workbook. This stops the workbook from referencing itself during a refresh, preventing the file lock.
Does this issue only affect corporate SharePoint networks?
No. This conflict also affects personal devices, such as Windows 11 Home computers, that utilize personal OneDrive accounts for cloud synchronization.
