software

When I open a worksheet with queries, I always get a message quot; Enable
automatic refreshquot; or quot;Disable automatic refreshquot;.
Normally it has to work without prompting me this question. Where can I set
this on automatic? I already tried in Tools-gt;options-gt;Edit and I took off
the quot;vquot; 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537612Hello Dave,

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

Reg, Marcquot;davesexcelquot; wrote:

gt;
gt; if this is for a table, you could right click on the table and select
gt; table options
gt; Enable 'Refresh on Open'. This will refresh the Table data everytime
gt;
gt; the workbook is opened.
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537612
gt;
gt;

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

quot;Marc Daemsquot; skrev:

gt; Hello Dave,
gt;
gt; Thanks, but I found already the answer at
gt; support.microsoft.com/default.aspx/kb/248204
gt;
gt; Reg, Marc
gt;
gt;
gt; quot;davesexcelquot; wrote:
gt;
gt; gt;
gt; gt; if this is for a table, you could right click on the table and select
gt; gt; table options
gt; gt; Enable 'Refresh on Open'. This will refresh the Table data everytime
gt; gt;
gt; gt; the workbook is opened.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; davesexcel
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=537612
gt; gt;
gt; gt;