'%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 Shared Workbook Links Showing Incorrect References
Question details
Users need to resolve incorrect formula references and #VALUE! errors in a shared Excel workbook hosted on SharePoint.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users are collaborating on an Excel workbook hosted on SharePoint, and worksheets are being copied.
- Observed behavior
- Copied worksheets update formula references for one user but not for others, and Excel for the web may display #VALUE! errors.
Ensure that you have a stable internet connection and that AutoSave is turned on in your Excel application before proceeding with troubleshooting.
Wait for SharePoint and OneDrive Synchronization
Allow the cloud services to fully synchronize changes before multiple users access the file to resolve reference mismatches.
When structural changes like copying worksheets are made in a shared workbook, it can take time for SharePoint and OneDrive to sync these changes to all users. Accessing the file too quickly can result in broken links or #VALUE! errors.
Look at the top-left corner of your Excel desktop application and verify that the AutoSave toggle is turned on.
After copying worksheets or updating linked formulas, wait a few minutes for OneDrive or SharePoint to finish syncing before another user opens the workbook.
Open the workbook in Excel for the Web and compare it with the desktop version to confirm that the synchronization has completed and the #VALUE! errors have disappeared.
Submit a Microsoft 365 Service Request
If synchronization does not fix the issue, your Microsoft 365 administrator will need to raise a support ticket with Microsoft.
Collaborate Seamlessly with WPS Office
Experience smooth document collaboration without the hassle of complex sync errors. WPS Office is a free, lightweight alternative that offers robust cloud integration, real-time co-editing, and perfect compatibility with your existing Excel files.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite to your device.
- 2. Upload to WPS Cloud: Save your spreadsheet to the built-in WPS Cloud to enable secure, real-time synchronization.
- 3. Invite Collaborators: Click the 'Share' button in the top right corner to invite your team members to view and edit the workbook simultaneously without reference errors.
Frequently Asked Questions
Why am I seeing #VALUE! errors in Excel for the Web but not on the desktop?
This discrepancy typically occurs because SharePoint or OneDrive hasn't finished syncing the latest formula calculations from the desktop app to the cloud server. Allowing the sync to complete usually resolves the error.
How can I prevent formula reference errors when sharing workbooks?
Ensure all collaborating users have AutoSave enabled. Try to avoid having multiple people heavily restructure the workbook (such as copying entire sheets) at the same time, and always let the file sync completely after major structural changes.
What should I include when reporting a shared workbook issue to Microsoft Support?
Always provide screenshots of the specific errors, detail whether the issue occurs on the web or desktop version, and include a sanitized sample workbook with all confidential and private data removed.
