Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit data connection properties
I use Excel to connect to a datasource for a program that used to use mapped
drives and a different method to validate user and password. In the new version, only unc paths are used to the data and the user name and password are now using .net 2.0 components to validate. My existing worksheets will no longer refresh though I can create new connections to the data. Is there any way to update the connections in the worksheet without having to rebuild the entire thing? kj |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit data connection properties
What I did last month for somebody was to write a macro which retrieved the
SQL statements from the query. Then the person used the SQL editor and pasted the retrieved SQL statments into a new Query. You can't just can't change the Connection. "karenj900" wrote: I use Excel to connect to a datasource for a program that used to use mapped drives and a different method to validate user and password. In the new version, only unc paths are used to the data and the user name and password are now using .net 2.0 components to validate. My existing worksheets will no longer refresh though I can create new connections to the data. Is there any way to update the connections in the worksheet without having to rebuild the entire thing? kj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Connection | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
always recheck data connection library in MOSS for latest data sou | Excel Discussion (Misc queries) | |||
How do I delete or edit this- file properties statistics in excel. | Excel Discussion (Misc queries) |