Excel Issue

[Newbie19]

I Know this isn't for excel, but its a windows program. I have an excel work book that runs a query from a db. However, when ever I open the workbook a very annoying box comes up asking do I want to enable automatic refresh or disable automatic refresh.

I've hit one, but once I save and shut the book and then reopen it, it ask me again.

How do I get rid of this box for good?

Thanks.

[epots9]

which version of excel are u running?

cuz in excel 2007, u go into Logo->excel options->trust center->trust center settings->external content

u want to enable the automatic update for all wookbook links

M$ says its not recommanded, but if thats that u want who cares what they say.

good luck

[Newbie19]

Excel Issue

which version of excel are u running?

cuz in excel 2007, u go into Logo->excel options->trust center->trust center settings->external content

u want to enable the automatic update for all wookbook links

M$ says its not recommanded, but if thats that u want who cares what they say.

good luck

Its excel 2003, and when I open the book I get a query refresh box.

The box gives me two options to either disable or enable. I hit one, yet when I save/close and then reopen the doc, It appears again.

Any ideas?

Thanks.



Thanks.

[epots9]

Its excel 2003, and when I open the book I get a query refresh box.

The box gives me two options to either disable or enable. I hit one, yet when I save/close and then reopen the doc, It appears again.

Any ideas?

Thanks.



Thanks.

ok, i don't have access to an excel 2003 (only 2002 and 2007) but if its like 2002 then u would have to do:

• This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.
  
• On the Tools menu, click Options, and then click the Edit tab.
  
• Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.

tell me how its goes.

good luck

[Newbie19]

ok, i don't have access to an excel 2003 (only 2002 and 2007) but if its like 2002 then u would have to do:

• This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.
  
• On the Tools menu, click Options, and then click the Edit tab.
  
• Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.

tell me how its goes.

good luck

Thanks, I just tried it. It didn't work. I wish I could show you the image, but it does like me today it seems.

Thanks for the help.

[epots9]

i hope this does what u need http://support.microsoft.com/kb/248204

**be careful in your registry!

good luck

[Newbie19]

i hope this does what u need http://support.microsoft.com/kb/248204

**be careful in your registry!

good luck

Thank you, this will be of great help...thanks for the advice...I have a pretty bad history in the registry.

[Newbie19]

Thank you, this will be of great help...thanks for the advice...I have a pretty bad history in the registry.

It worked, thank you very much.

[epots9]

It worked, thank you very much.

np, anytime

it took some time cuz M$ makes it hard to find any info on pervious products when a newer one is out

[Newbie19]

np, anytime

it took some time cuz M$ makes it hard to find any info on pervious products when a newer one is out

M$ makes a lot hard, that is why I'm a linux fan.

Thanks again.