Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cells Not Updating (97:SR2)

    In larger XL files (5-7meg) I have noticed that cell references to different sheets within the same workbook are not updating. The calculation is set to automatiic but the cells do not get updated until I F2 each cell.

    As an example
    Sheet1!A1=+Sheet22!B30
    Sheet1!A2=+Sheet30!B10
    Sheet1!A3=+Sheet40!B45
    and so forth.

    If cell B30 on Sheet22 changed one would think the cell in A1 Sheet 1 would change accordingly.

    Any thoughts on why this is happening? MSoft KBA 108799 suggests using the F2 approach.

    I wonder if this is an issue with XL97 and was fixed in XP?

    Thanks,
    John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cells Not Updating (97:SR2)

    Have you tried using ctrl-alt-F9?

    There have been some issues with recalc problems reported under particular instances and there is a patch for xl97 recalc:

    http://support.microsoft.com/default.aspx?...kb;EN-US;171339
    http://support.microsoft.com/default.aspx?...8&Product=xlw97
    http://support.microsoft.com/default.aspx?...4&Product=xlw97

    Steve

Posting Permissions

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