LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 07, 04:48 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Sep 2007
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?

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 05:44 PM
Data Connection - Active Directory Rob Excel Discussion (Misc queries) 1 August 11th 06 06:56 PM
Data Connection wizard quits working [email protected] Excel Discussion (Misc queries) 0 June 22nd 05 03:59 PM

All times are GMT +1. The time now is 09:07 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017