This video shows how to use simple script to check if getting data from Excel will work for 3rd party apps. Script we used could be downloaded using this link: http://download.analystsoft.com/tools/excel-selection.scpt
Usually issue with Excel connectivity happens when you upgrade your Mac OS (Mavericks->Yosemite) or used Mac OS Migration Assistant. In this case Office removal and a clean install should help. To remove Office – please open Finder and in the Go menu, click Applications, drag the “Microsoft Office 2011” folder to the Trash. Then please follow this guide from Microsoft on how to install Office:
To do a clean install – download Office 2011 installer (you need a serial number for Office activation) and follow instructions: https://www2.downloadoffice2010.microsoft.com/macdl/registerkey.aspx?culture=en-US&ref=macdl
Be sure to follow us on Vimeo to view a range of new tutorials on data analysis with Microsoft Excel for Mac.