Excel data connections to other excel docs located in sharepoint library : howto ?
Hello
I have an excel document where I want to import data from another excel document which is located in a sharepoint document library.
When I create a connection to this Http:// ... xls file , the datasource points to a document download in my Temporary Internet Files\Content.MSO folder.
This is problematic when somebody else want to update the excel document and refresh the data.
What is the best approach ?
Excel 2007
Sharepoint 12.0
May 13th, 2011 10:53am