View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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