Hi everyone,

I have a workbook that must be shared among 5 users with full read/write access. I have a query built in to a hidden sheet that feeds fields on the first sheet. When the workbook is not shared, I am prompted to refresh the query when I open the workbook and everything functions properly. When the workbook is shared, I am still prompted to refresh the query when the workbook opens, but the query does not seem to refresh automatically as it should.

What can I do to ensure that the query will refresh each time the workbook is opened? What about each time it is opened by an additional user?

Thanks and best regards,
ACurtis802