View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Auto Update Linked data

Hi,

Try - In the workbook with links, choose Edit, Links, Startup Prompt and
choose the first option.

--
Thanks,
Shane Devenshire


"Ingebelle''s" wrote:

spreadsheet (a) that was open before new data saved as another spreadsheet
(b) no longer updates automatically without opening & closing (a) or using
the EditLinks feature. I believe the auto refresh disappeared when my
company upgraded MS Office from Proffesional to XP. Using Excel 2003.