How to enable query refresh?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open a worksheet with queries, I always get a message " Enable
automatic refresh" or "Disable automatic refresh".
Normally it has to work without prompting me this question. Where can I set
this on automatic? I already tried in Tools->options->Edit and I took off
the "v" at Ask to update automatic links but it still asking me the same
questions by re-opening the worksheet.
Please your help is really welcome.
 
if this is for a table, you could right click on the table and select
table options
Enable 'Refresh on Open'. This will refresh the Table data everytime

the workbook is opened.
 
Back
Top