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? |
All times are GMT +1. The time now is 07:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com