Excel and 'refresh data' dialog

[Guest]

Hello,

I have a shared Excel spreadsheet on a server. It is linked to an Access
database table via Windows Query. Once published to the server several people
update different cells and save it when closing. I refresh the spreadsheet to
append any new records or delete any closed records originating from the
Access table. My problem is the 'refresh data' dialog box appears when others
open the spreadsheet to update it. I don't want that to happen...only when I
need to refresh it. Can that be done? As a side note, I'm not aware of any
other method for appending rows to a spreadsheet that would come from another
spreadsheet.

Thanks for your time and help.

 

[Guest]

Have you right clicked on the table and selected edit, options or similar.
You should get a dialog with a lot of options. I believe there is an option
there not to refresh the data. I don't have a query table handy to check but
it shouldn't take you but a second.