How to determine if a Excel Spreadsheet references external datasources.
Posted on 2013-05-16
Can anyone point me in the right direction as to how in VBA terms I could determine if a cell in an Excel spreadsheet was getting it's data from an external datasource Website, DB other workbook etc. Also if it's possible is there a way to determining what the external datasource was, this may be stretching the limits of vba I think though.
Any help would be much apperciated.