excel - Multiple SQL Data Connections Need to be Changed to a New Source -


i have 269 data connection files live linked excel sheets. these excels sheets refreshed coworkers , myself daily. updating our servers, , data source these connections changing. have change each data connection new source.

i know can click on each data connection, opens excel sheet connection properties. can change source here, save , move on.

with 269 connections, method may take while. wondering if there quicker way change these connections new source?

thank you!


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -