How to make excel linked to another excel file in Sharepoint 2010 -
i have 3 excel files uploaded in sharepoint 2010. in 1 theme every cell links 1 of 3 excel files. in sharepoint without opening in excel on desktop, there way update linked data? there way run vba?
sorry bad english.
vba , external data ranges (also quoted query tables) not supported sharepoint 2010 , neither sharepoint 2013 while using excel services view these files online.
these features supported if open them within excel itself.
here complete answer microsoft: https://msdn.microsoft.com/en-us/library/office/ff595319.aspx
Comments
Post a Comment