Solved

Sharing an Excel workbook with external data source.

Posted on 2011-09-07
2
250 Views
Last Modified: 2012-05-12
Hi there,

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.

Cheers,

Nick
0
Comment
Question by:Nemins
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
Comment Utility
Not really, I'm afraid. Shared workbooks are extremely limited, as well as being prone to corruption.

I suppose you could use code to load the data from the external sources and paste it into the worksheet using ADO, but personally I'd avoid sharing the file if at all possible.

Regards,
Rory
0
 

Author Closing Comment

by:Nemins
Comment Utility
Thanks for the response!

I had feared this was the answer, and you have confirmed my suspicions.

Regards
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now