View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.links
TADropik TADropik is offline
external usenet poster
 
Posts: 5
Default Auto update a linked Cell

Bingo . . . This works EXCELLENT.
We are using Excel 2003 SP3

Thank you for your help.

"Bill Manville" wrote:

Your Excel formula link is not a "remote reference" but an "external
link". What happens on opening the workbook depends on the version of
Excel you are using - please advise.

In Excel 2003, look for the Edit Links Startup Prompt setting.
Change it if necessary to "Let users decide whether to display the
alert or not".


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup