Troubleshoot Excel External Links to Microsoft Project Files
Question details
The user needs to resolve #REF! errors and incorrect source references in a large set of Excel links connected to Microsoft Project files.
- Product
- Microsoft Excel and Microsoft Project
- Device & OS
- not provided
- Scenario
- Many cells in an Excel workbook are linked to Microsoft Project data, and the user needs the links to remain accurate after updating or pasting them.
- Observed behavior
- Some external links return #REF! errors, while newly pasted links may point to an incorrect Microsoft Project source file.
Make sure every Microsoft Project source file is available and opens normally before updating links. Identify the intended source folder and use a stable local or UNC network path rather than a mapped drive letter when possible.
Check and repair Microsoft Project source paths in Excel
Use this method when existing Excel links show #REF! errors or refer to a moved, renamed, or unavailable Project file.
External links can break when a source Project file is renamed, moved, unavailable on the network, or referenced through an inconsistent path. There is no guaranteed number of links that makes a large linked workbook reliable.
In Excel, open the affected workbook and select Data > Edit Links. In versions where Edit Links is not shown, go to Data > Queries & Connections > Workbook Links.
Select a listed source and verify that the displayed path points to the correct Microsoft Project file. Check whether the file exists at that location and that you have permission to open it.
Select the incorrect or unavailable source, choose Change Source, and browse to the correct Microsoft Project file. Use the same stable folder path for all users who refresh the workbook.
Close the linked Project files where possible, then choose Update Values in the links manager. Confirm that #REF! cells are replaced with valid values or formulas.
Save the workbook under a new working copy, close it, reopen it, and update the links again to confirm that the repaired paths persist.
Replace large direct links with a controlled Project export and import workflow
Use this approach when the workbook contains many Project links or links frequently fail during updates.
Use WPS Office Spreadsheets for Project Data Exports and Excel Workbooks
If Microsoft Excel external links to Microsoft Project files remain unstable, WPS Office provides a free, lightweight spreadsheet alternative for opening Excel workbooks and working with exported Project data. Its familiar spreadsheet interface helps you migrate existing files, organize imported task data, and reduce dependence on fragile cell-by-cell external links.
Frequently Asked Questions
Why do Excel links to Microsoft Project show #REF! errors?
#REF! errors commonly occur when the linked Project file was moved, renamed, deleted, or cannot be accessed through its saved path. Open Excel and check Data > Edit Links, or Data > Queries & Connections > Workbook Links, to review the source location.
Is there a safe maximum number of external links between Excel and Project?
No fixed number guarantees reliable external links. Reliability depends on file paths, network availability, link structure, update timing, workbook condition, and whether files are being changed while links refresh.
Why do pasted external-link formulas point to the wrong Project file?
When you copy a formula, Excel can retain the original external workbook reference or adjust relative references. Select a pasted cell and inspect the formula bar before filling or pasting the formula across a large range.
Should Microsoft Project files be open when Excel updates links?
Keeping source Project files closed during the refresh can reduce simultaneous-update conflicts. Ensure the files are available at their expected paths, then update links from Excel's Data tab.
What is a more reliable alternative to direct Project-to-Excel cell links?
Export the needed Project data to a controlled CSV or Excel file and import it as one data source. In Excel, use Data > Get Data > From File, then use Data > Refresh All when the export is updated.
