Dear all:
Succesfully created an Excel-based workbook where data are sourced from Smartsheet, by installing the SMartsheet ODBC data connector on a Win10 machine; created and configured a DSN; and configured said DSN with my Smartsheet user credentials and API token from my smartsheet account. Let's call me user A.
The Smart sheet in question, created by user A, is shared between users A and B.
User B needs to gain access to my workbook. Better put, I need users A and B to be able to each work from the same workbook file - and be able to update the data based on the ODBC live connection to Smartsheet.
How do I best do this?
A- configure a Windows machine for user B with User A's credentials in the DSN?
B- configure a Windows machine for user B with User B's credentials in the DSN?
C- other?
Thanks in advance for any and all help!
Luc