Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Update Linked files (Excel 2002)

    I have a client that has 20 files that are linked to a summary sheet. Many different users updates these sheets. In Office 97, the summary sheet would be automatically updated whenever the data was changed in the linked sheet. This stopped working in Excel XP(2002). The client must now manually run update on either the input sheet or the summary sheet to see the updated data. Since the only thing I know about Excel is how to make a list, I'm a little bit lost. Any help would be appreciated.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Auto Update Linked files (Excel 2002)

    Hi,

    You might be able to fix this by going into Tools|Options|Calculation and checking the 'Update remote references' checkbox.
    You might also want to make sure the 'Ask to update automatic links' checkbox under Tools|Options|Edit is checked too.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •