Checking the Data Source of Your Excel Query

When working with Excel, it's important to know where your data is coming from, especially when dealing with complex queries. Here’s a step-by-step guide to help you identify the data source of your Excel query:

1. Open the ODBC Data Sources app on your device:

2. Look for SysproCompanyR or SysproCompanyS connection names and select configure on the right.

3. Review the entry next to “Server”. If your server entry is “CPT-SQLREP-01”, please log a call so that we can amend the connection to the correct server.