Forum Discussion
Excel Spreadsheets that are linked
- It is possible that having password-protected cells within a workbook could cause links to be disabled when the file is opened in OneDrive. However, there could be other reasons for this issue as well. For example, there may be some settings in your workbook that cause it to open as read-only. You could try creating a new workbook with a password to protect it and then share it with the user to see if it is also read-only.
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.
- 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.