How to enable query refresh?

[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.

 

[davesexcel]

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.

 

[Guest]

Hello Dave,

Thanks, but I found already the answer at
http://support.microsoft.com/default.aspx/kb/248204

Reg, Marc

 

[Guest]

Hello Marc
have you found other alternatives for this?
this changes influence on all excel files and be made on many machines.
can a macro do the same just in one file?

on AutoOpen ... (something like that)???

stella

"Marc Daems" skrev:

Hello Dave,

Thanks, but I found already the answer at
http://support.microsoft.com/default.aspx/kb/248204

Reg, Marc