Password For Link To External Data

**eric_blakey** · 07-25-2008, 11:07 AM

hi,
does anyone know where the password is stored for worksheets that link to external data ? ..... when i click data > refresh data on this type of worksheet, if my password has changed in the source database since my last refresh, i can't refresh the data and i have to make a brand new worksheet by exporting all over again from the source system with the new password details embedded in .....

any help would be much appreciated ......

eric.b.

**Ron Coderre** · 07-25-2008, 11:33 AM

The information you're looking for is stored in the Connection.

One easy way to see and edit the Connection info (and the SQL query)
is to use the Pivot Play Plus free add-in, available at
Debra Dalgleish's website:
http://www.contextures.com/xlPivotPlayPLUS01.html

Does that help?

**eric_blakey** · 07-25-2008, 12:08 PM

thanks ron, ......

unfortuantely i do not have the required rights to download software to my company laptop ..... you said 'one easy way' .... are there any other ways please ??

rfds,

eric.b.