Sharing an Excel workbook with external data source.
Posted on 2011-09-07
Is there any way of sharing an Excel workbook which resides on a network drive, which contains external data sources?
At the moment when I am trying to share the document, I get an error saying that it contains Excel tables and XML maps, and these must be removed in order to share the document.
Is there any way around this? As its a pain to keep adding the data sources when we want to refresh the data and bring in the new data from the external source.