Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Linked Information (Excel 97)

    Does anyone know if there is a way to update information which is linked to another worksheet without having to open the worksheet?

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Linked Information (Excel 97)

    Edit/Links/click Update button

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Linked Information (Excel 97)

    I'm guessing that the "wrong" values were saved in the closed workbook and when opened, automatic calculation "fixes" these values. You should open the linked ss's recalculate, save & close all & try again. This should work.

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Linked Information (Excel 97)

    I have triple checked these settings and this method is not working. I actually have to open the both spreadsheets before the values will update properly. The objective is to have users update one spreadsheet and mangers view summarys which are linked in a seperate spreadsheet. Any ideas?

Posting Permissions

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