Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert-Name-Define How to change formula after-the-fact? | Excel Worksheet Functions | |||
Determing Value From Date | Excel Discussion (Misc queries) | |||
Factorial (like =FACT) function? | Excel Worksheet Functions | |||
Adding a date stamp to each cell in column - after the fact | Excel Discussion (Misc queries) | |||
Formula for determing average based on weighting | Excel Worksheet Functions |