P
Paul
Hi Everyone,
I hope someone is able to provide some input.
We have a ODBC Query and is working and refreshing well via Get External
Data. Now we are considering sharing the workbook between five users (yes, a
lot of downfalls with sharing) anyways, when we do put into "shared" by
Tools>Share Workbook, we are not getting the ODBC to work any more. The
options are also greyed out. Is there a workaround? The reason that we use
the ODBC is that we have a macro (Class1) that gets triggers and performs a
task after the refreshing of data. I've tried ADO but it does not help me
with the triggering of the macro. Thanks in advance!!! Paul
I hope someone is able to provide some input.
We have a ODBC Query and is working and refreshing well via Get External
Data. Now we are considering sharing the workbook between five users (yes, a
lot of downfalls with sharing) anyways, when we do put into "shared" by
Tools>Share Workbook, we are not getting the ODBC to work any more. The
options are also greyed out. Is there a workaround? The reason that we use
the ODBC is that we have a macro (Class1) that gets triggers and performs a
task after the refreshing of data. I've tried ADO but it does not help me
with the triggering of the macro. Thanks in advance!!! Paul