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
Bookmarks