Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreadsheet doesn't update (Excel 97)

    Hello,
    Anyone know why a spreadsheet would not automatically update the calculations when new amounts are entered? It did in the beginning but now it doesn't.
    Thanks for your help!
    Louise

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet doesn't update (Excel 97)

    Tools, Options, calculation, set to automatic.

    Excel keeps the setting of this option of the first workbook you open in a session. I had this happen to me after setting calculation to manual and subsequently saving my "Personal.xls" (which always loads as the first workbook....)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet doesn't update (Excel 97)

    It worked! Thanks!
    Louise

Posting Permissions

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