Determing the SQL Datasource After the Fact
 

Good morning,

Excel 2003 SP2

I have several Excel spreadsheets where I have linked to a SQL Data View. I
am now needing to determing exactly which view the data is generated from.
Is there a way to do this? I have searched the message boards but can't seem
to find the answer. I think part of my problem is which words to search on.

Thanks,
Gilley

Determing the SQL Datasource After the Fact
 

Hi

Try looking under DataImport External DataData Range properties

--
Regards

Roger Govier


"Gilley" wrote in message
...
Good morning,

Excel 2003 SP2

I have several Excel spreadsheets where I have linked to a SQL Data
View. I
am now needing to determing exactly which view the data is generated
from.
Is there a way to do this? I have searched the message boards but
can't seem
to find the answer. I think part of my problem is which words to
search on.

Thanks,
Gilley

Determing the SQL Datasource After the Fact
 

Thanks for the response. However, that option only shows 'Query from REDO'
where REDO is our database name. It doesn't show 'MonthlySpecialsMailer'
which is the name of the SQL View.

"Roger Govier" wrote:

Hi

Try looking under DataImport External DataData Range properties

--
Regards

Roger Govier


"Gilley" wrote in message
...
Good morning,

Excel 2003 SP2

I have several Excel spreadsheets where I have linked to a SQL Data
View. I
am now needing to determing exactly which view the data is generated
from.
Is there a way to do this? I have searched the message boards but
can't seem
to find the answer. I think part of my problem is which words to
search on.

Thanks,
Gilley