Contents
Link to data in other worksheets and workbooks. You can link to a cell in another workbook by starting to create your formula, displaying the worksheet that contains the value you want to use, and then selecting the cell or cell range you want to include in the calculation.
What does automatic update of links has been disabled mean in Excel?
Why Does it Appear? This warning appears in excel workbooks that have external links. Basically this warning notifies the user that the workbook will be getting data from an external source. In order to allow the workbook to connect to the external source you will need to grant it permission.
Do you need to link Excel files to SharePoint?
The Excel files need to be in SharePoint on-premises or SharePoint Online. There is an option in the tool to turn this on under Links->Manage-Options, this works well and is in use by many of our customers. The tool also provides the worksheet and the cell coordinates in the reports so you know where links are present.
This should work, but I believe it is easier to move the data to Sharepoint and handle it in there. You can still use Excel for charts and pivot table stuff, but use Sharepoint to store the data. The link you posted Michal, is to Excel Services which would display it as a web based data format.
Hi there, I currently link multiple workbooks together, pulling the data from one to another. The spreadsheets are saved on sharepoint and when I update one, the other doesn’t always update. I have read that you need to have both spreadsheets open in order for them both to update accurately.
Can You Link an Excel file to another Excel file?
Right now in all my tests, SharePoint Online disables the links in my excel file to cells in another excel file and I cannot find anyway to change the links. This is a pretty basic function that is used extensively in excel so I’m a little surprised that this is not available in SP Online.