I don't get what you mean. If I remove the links, then I cannot update
the stock quotes.

Why is no one helping here??? I would like to understand a good method
form updating data into a workbook from an external workbook? This must
be a common basice function.

Thanks.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture




In article ,
fluffymoore wrote:

You Got It. the best and only way is to remove your links.

"dk_" wrote:

Running Excel97, and Excel98 Mac.

I'd like to manually be able to control updating of 'linked references'
in a few workbooks, without having to click the 'No' button in the
dialog box that displays when I open each workbook containing links.

If I uncheck the choice on the 'ToolsOptionsEdit tab', (Ask to
update automatic links), then I don't get the 'ask" dialog box upon file
opening, but then the links update automatically.

I have three columns of stock quote data that I download, and I'd like
to update each workbook manually by choice.

What's the best way to do this?

Maybe 'linked references' is not best way to do this?

Thank you in advance for any help.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture