J
JanetW
I am trying to get a linked Excel workbook from locking out access t
the workbook it is linked to. The "Report" workbook is linked via th
Import External Data command to a "Log" workbook which contain
real-time work log data for several employees. The Log is set up as
shared workbook which syncs user's updates every 10 minutes. (Th
Report and Log workbooks can not be combined for various reason.)
The problem is that when the manager opens the Report workbook and doe
Refresh Data, he effectively locks out anyone, including himself, fro
opening the Log or saving their changes if they already have the lo
open. This despite that the Log is set up as a shared file.
The text of the query lists a "Mode" property which by default is se
to "Share Deny Write". I've tried various other attributes to try t
get the Report to either respect the sharing of the Log, or open th
log as read only so other can still write to the log. Is "Mode" th
query property I should be setting to allow this? What should thi
property be set to in order for the Report to be updated withou
locking out other people's access to the Log?
Thanks!
the workbook it is linked to. The "Report" workbook is linked via th
Import External Data command to a "Log" workbook which contain
real-time work log data for several employees. The Log is set up as
shared workbook which syncs user's updates every 10 minutes. (Th
Report and Log workbooks can not be combined for various reason.)
The problem is that when the manager opens the Report workbook and doe
Refresh Data, he effectively locks out anyone, including himself, fro
opening the Log or saving their changes if they already have the lo
open. This despite that the Log is set up as a shared file.
The text of the query lists a "Mode" property which by default is se
to "Share Deny Write". I've tried various other attributes to try t
get the Report to either respect the sharing of the Log, or open th
log as read only so other can still write to the log. Is "Mode" th
query property I should be setting to allow this? What should thi
property be set to in order for the Report to be updated withou
locking out other people's access to the Log?
Thanks!