Forum Discussion
Excel Spreadsheets that are linked
Hi,
Thanks for trying to help me. I created a folder and uploaded the excel files. I entered data into the input sheets. When I opened the totals files it didn't update.
I got an error message stating that the links are disabled. Links to external workbooks are not supported.
As said earlier, if you have an Excel workbook saved on your hard drive and want to link it to another PC, you can save the workbook to a cloud storage service like OneDrive.
This way you can access the workbook from any device and make changes that will be automatically synced.
However, it is important to note that changes made to a copy of the workbook are not automatically synced to the original workbook.
To ensure that all changes in both workbooks are synchronized, you should always edit the same workbook and not make a separate copy.
Please provide the following information in order to be able to assist further should it be required again:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
- All of the files are saved on OneDrive. The links are disabled. Could this be because I have certain cells within the workbooks password protected?
- It’s important to note that if your clients move any of the extracted spreadsheets to a different location on their computer, the links between the spreadsheets may break. To avoid this, make sure that your clients keep all the extracted spreadsheets in the same folder.
- 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.