Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default always recheck data connection library for latest connection strin

I am starting a PivotTable that uses a connection found in my data connection
library in MOSS. It downloads that connection string and stores it in the
xlsx file (as I see when I unzip the xlsx). If I modify the connection string
in the data connection library, it appears Excel doesn't recheck that data
connection library and get the latest connection string the next time I open
that workbook. This is a problem as I thought the data connection library
would allow us to abstract the physical server names from the end user.

Is there a way to set it up so that Excel automatically rechecks the data
connection library and gets the latest connection string?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Connection Security in Excel 2007 Jason[_5_] Setting up and Configuration of Excel 5 August 29th 07 04:04 AM
remove data connection Robby Excel Discussion (Misc queries) 0 July 3rd 07 02:12 PM
Connection to external data sources in Excel Thomas Wellington Excel Discussion (Misc queries) 0 March 1st 07 06:44 PM
Data Connection - Active Directory Rob Excel Discussion (Misc queries) 1 August 11th 06 06:56 PM
Data Connection wizard quits working SJR@mbci Excel Discussion (Misc queries) 0 June 22nd 05 03:59 PM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"