Hello, I am trying to setup an ODBC connection to MS SQL Server from an Excel 2003 workbook. Whenever the workbook is in non-shared, single-user mode, the connection works fine and the linked data can be refreshed, etc.; but when shared mode is activated the data becomes static and the connection no longer seems to work.
Is this a limitation of shared Excel workbooks? I have searched the MS knowledge base and can find no mention of this situation. Links to other workbooks still work fine, I don't know why the ODBC connection would die.
Thanks for any help in advance,
Matt
Is this a limitation of shared Excel workbooks? I have searched the MS knowledge base and can find no mention of this situation. Links to other workbooks still work fine, I don't know why the ODBC connection would die.
Thanks for any help in advance,
Matt