Live Data Connector (Excel sheet Portability) Question
I'm using the Live Data Connector to import data from smartsheet to excel. I started by using the (not recommended) Excel Data connector because I was less familiar with other methods but the data imports without any problems. Some connections to the smartsheet data are associated with an .odc file saved on my local computer so that when someone opens the excel file from another location they're hit with a bunch of "can't connect" alerts. I'm trying alternative methods of establishing a connection that wouldn't need for the .odc files (Microsoft Query or by going through the query wizard). Just wondering if anyone is linking excel with smartsheet data and if they have any problems when the excel sheet is used by others.