Switching Data Sources in Excel 2007
Folks who connect to external data from Excel will sometimes encounter the following user scenarios:
Switch between test and production data sources
I want to test my spreadsheet while connecting to a test server, but then want to switch from the test server to a production server. Or I’ve got a spreadsheet that’s getting its data from a production server and I want to switch to a test server while I make some changes to the spreadsheet.
Tags: excel