Update links without being prompt
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.
--
Gary''s Student - gsnu200744
"George" wrote:
The 2003 version of Excel asks if i want to update links when
opening a file with external links. The external links are csvs so is there
a way to automatically update without being asked?
Thanks
George
|