How to make excel linked to another excel file in Sharepoint 2010

0
votes

I have 3 Excel files that are uploaded in Sharepoint 2010. In one theme every cell links to one of three Excel files. In Sharepoint without opening in Excel on desktop, is there any way to update linked data? Is there any way to run VBA?

Sorry for my bad English.

1
excelsharepointsharepoint-2010excel-2010vba

1 Answers

0
votes

VBA and external data ranges (also quoted query tables) are not supported by SharePoint 2010 and neither so by SharePoint 2013 while using Excel Services to view these files online.

These features are only supported if you open them within Excel itself.

Here is the complete answer from Microsoft: https://msdn.microsoft.com/en-us/library/office/Ff595319.aspx