Hi,

I've set up a spreadsheet to extract external data from an SQL database
using the Import External Data function.

This spreadsheet contains about 50 queries, that can convenently be
refreshed all at once.

Problem is that I've saved the password on each of these queries as I was
setting them up, and now my password has changed.

Is there any easier way to change the password for all of these queries at
once? Right now, I have to uncheck the Save Password box on the Data Range
Properties, save the workbook, close it, open it back up, change the
password, Re-check the save password box, and again save the workbook.
Repeat 50 times (once per query).

I've tried opening the workbook in Notepad, and doing a find/replace, but
this results in a corrupted workbook. Any ideas?

Thanks,

Sam