Can I use an excel book in SharePoint AS my eternal data source?

Is it possible to use a data table from an excel workbook that's on SharePoint as an exteal data source to a workbook on my local drive or another location in SharePoint?