A client of a client has contacted me with a question

He has a large document which uses Microsoft Query and downloads information from Sage, which is refreshed every five minutes

The information uses a range of pivot tables to analyse and update the information, and it all works well

He wants to display this information in real time in a meeting room

I suggested sharing the file so that it could be opened on more than one computer at the same time

He said that as soon as he uses the Shared facility, the ability to refresh is greyed out

As I do not have access to these files, and am unable to replicate this as I am a sole trader with a single computer, I am a little perplexed

Does sharing a file, while using Query, affect the ability to update?

He said that as soon as he removed the Share property, it updated

I would really appreciate your help please

Thank you so much

Lynne