Hello John,
I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.
I'm sorry to hear that you're having trouble with Excel files with links to a file on OneDrive on your MacBook Air with macOS Sonoma 14.1. Here are a few things you could try:
- **Check Your Links**: Make sure the links in your Excel file are correct and the files they're linking to exist in the specified location.
- **OneDrive Sync Issues**: There might be an issue with OneDrive sync. You can try restarting OneDrive or updating the OneDrive sync app for Mac.
- **File Path Issues**: Linking files using a local file path doesn’t work when uploading to OneDrive as when you open it on another PC (or Mac) then file path isn’t valid.
- **Reset OneDrive**: You could try resetting OneDrive on your Mac². Here are the steps:
- Quit OneDrive. (Select the cloud icon in the top tray, then select Settings > Quit OneDrive.)
- Find OneDrive in your Applications folder.
- Right-click OneDrive and select Show Package Contents.
- Browse to the Contents > Resources folder.
- Double-click ResetOneDriveApp.command (or ResetOneDriveAppStandalone.command, if you're using the standalone app).
- Start OneDrive and finish the setup process.
https://answers.microsoft.com/en-us/msoffice/forum/all/working-with-excel-hyperlinks-to-onedrive-files/cdac205e-b6c1-4ba4-b41e-b5fefffcd51b
https://support.microsoft.com/en-us/office/fix-broken-links-to-data-84f494f9-1da9-460a-aa83-aba07108bc97
https://support.microsoft.com/en-us/office/fix-onedrive-sync-issues-on-macos-e9f058fa-e542-361e-e26e-f199539dcf61
I hope this helps.
Best Regards,
Ibhadighi