When you have a spreadsheet or PivotTable saved, you might want to connect the data in it to data in another spreadsheet or database. You can do so by using the advanced features of Microsoft Excel, which support establishing a data connection to another data source from the new Excel worksheet. This chapter’s focus is on Microsoft Dynamics CRM, so the advanced features of Excel are not outlined.
For example, your department might have a budget model in Excel. You could connect it to your opportunities to assess whether you are on track to meet the budget numbers.