Consolidating database servers
If the external data source that you want to access is not on your local computer, you may need to contact the administrator of the database for a password, user permission, or other connection information.
If the data source is a database, make sure that the database is not opened in exclusive mode.
However, due to its resource-intensive nature, there are a few best practices that you need to follow.
The main benefit of connecting to external data is that you can periodically analyze this data without repeatedly copying the data, which is an operation that can be time-consuming and error-prone.
After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Field workers often create Excel spreadsheets to track data and run their processes. Here's how Carlsberg Danmark centralized business process management, created an orderly system with consistent data, and saved hundreds of hours in backoffice time.
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways.