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.


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537612

Hello Dave,

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

Reg, Marc


"davesexcel" wrote:


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.


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537612

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


"davesexcel" wrote:


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.


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537612