I'm new to using excel at a presentation tool for data
stored in a SQL Server database. I set up a data source
locally on my development machine between my development
SQL Server and Excel. Everything works fine and I am able
to make my graphs, etc. Now I'd like to distribute the
Excel workbook to management and change the data source to
look at the production SQL Server. I can edit the query,
but I can't get to anything that allows me to point to a
different data source, change users for security purposes,
passwords or databases. There has to be something there
I'm just not seeing. I can't imaging having to recreate
every Excel file just because the server gets renamed, add
or change users, etc. Thanks for taking your time to
answering my question.