Change Data Source

[Alfred]

There is an Excel Spreadsheet getting data from a SQL
Server via MS Query.

We have to send this Excel file to a consultant. However,
he says that he is not able to change the Data Source. We
would like to know is there any workaround ?

Thanks

 

[Nick Hodge]

Alfred

He should be able to by going into the data wizard again (Either standard
data or pivot table) and pressing 'back'. It should then point to the
existing source, or give an error at which point he should be able to
connect to a new one.

If not, accepting the error should eventually allow you to edit the query in
MSQuery and you can reconnect from here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Alfred]

In other words, when he opens the query:
Data --> Get External Data --> Edit Query, he gets an
error message and prompts for the Server Name.

What he needs to do is to change that Server Name to his
Server Name and corresponding Login ID as well.

In this way, he can access the query without problem ?

Thanks