I have several workbooks that each have 50+ tables spread across numerous sheets...each table is linked to a Postgres server via individual ODBC connections. Each connection has a query string with some common elements, like beginning & ending timestamps.

Say I want to change one of these timestamps across all 50+ queries without having to open each connection dialogue box individually. Is there some kind of Search & Replace function that will accomplish this? I know how to set up a macro to dynamically pass parameters to a single ODBC query string, but setting it up for 50+ unique queries seems unwieldy.