Forum Discussion
Excel Spreadsheets that are linked
Please keep in mind that hyperlinks are not the same in OneDrive as on a hard drive for an Excel workbook. If the same hyperlink on an Excel file saved on OneDrive is accessed from the OneDrive web, the hyperlink changes. You can try to recreate the link from Excel to the documents saved on the desktop OneDrive app and check.
You can create hyperlinks in an Excel workbook that work in OneDrive for other users by using the HYPERLINK function. The HYPERLINK function creates a link that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, Excel opens the file stored at the location of the link .
You can also type a URL directly into a cell or use the Hyperlink button in the Links group in Excel.
- Thank you for your feedback. I wish you continued success with Excel.
- Hi,
Thanks for all your help! I figured it out. In order for the totals spreadsheet to update the current data, the input spreadsheets can't be password protected. When I remove the passwords then the totals spreadsheet works.
