+ Reply to Thread
Results 1 to 5 of 5

Screen Refresh

  1. #1
    Michael H
    Guest

    Screen Refresh

    Hi.

    I'm using Excel 97 and Windows 2000 SP4. Tools>Options>Calculation is set
    to Automatic.

    I have a worksheet on which three cells are giving me a problem. These
    cells contain formulas dependant on other cells in the same worksheet. It
    seems that these cells are being updated/calculated when I change the cells
    on which they depend, but the screen is not being updated. I have to scroll
    down so that those three cells can no longer be seen on the screen, and then
    scroll right back up again, and then the new values can be seen. Or, I can
    Alt-Tab to a different application, then right back to Excel, and then the
    correct cell values are displayed. There are other cells on the same
    worksheet that also contain formulas, but do not exhibit the same behavior.

    I hope I have explained this well enough. Has anyone experienced similar
    problems? I would appreciate some advice on how to correct this.

    Thank you.

  2. #2
    Niek Otten
    Guest

    Re: Screen Refresh

    There was several issues with recalculation in early versions of Excel97.
    You need Service Pack 2 (SP2) to correct these. You can check your version
    in Help>About Microsoft Excel.

    --
    Kind regards,

    Niek Otten

    "Michael H" <MichaelH@discussions.microsoft.com> wrote in message
    news:FCF11E1E-BA5E-4160-8F4B-DF78768BC527@microsoft.com...
    > Hi.
    >
    > I'm using Excel 97 and Windows 2000 SP4. Tools>Options>Calculation is set
    > to Automatic.
    >
    > I have a worksheet on which three cells are giving me a problem. These
    > cells contain formulas dependant on other cells in the same worksheet. It
    > seems that these cells are being updated/calculated when I change the
    > cells
    > on which they depend, but the screen is not being updated. I have to
    > scroll
    > down so that those three cells can no longer be seen on the screen, and
    > then
    > scroll right back up again, and then the new values can be seen. Or, I
    > can
    > Alt-Tab to a different application, then right back to Excel, and then the
    > correct cell values are displayed. There are other cells on the same
    > worksheet that also contain formulas, but do not exhibit the same
    > behavior.
    >
    > I hope I have explained this well enough. Has anyone experienced similar
    > problems? I would appreciate some advice on how to correct this.
    >
    > Thank you.




  3. #3
    Michael H
    Guest

    Re: Screen Refresh

    Niek,

    Thanks for your reply. Help>About says "Microsoft Excel 97 SR-2", so it
    looks like Service Pack 2 (or Service Release 2) has been installed. Any
    other suggestions?



    "Niek Otten" wrote:

    > There was several issues with recalculation in early versions of Excel97.
    > You need Service Pack 2 (SP2) to correct these. You can check your version
    > in Help>About Microsoft Excel.
    >
    > --
    > Kind regards,
    >
    > Niek Otten
    >
    > "Michael H" <MichaelH@discussions.microsoft.com> wrote in message
    > news:FCF11E1E-BA5E-4160-8F4B-DF78768BC527@microsoft.com...
    > > Hi.
    > >
    > > I'm using Excel 97 and Windows 2000 SP4. Tools>Options>Calculation is set
    > > to Automatic.
    > >
    > > I have a worksheet on which three cells are giving me a problem. These
    > > cells contain formulas dependant on other cells in the same worksheet. It
    > > seems that these cells are being updated/calculated when I change the
    > > cells
    > > on which they depend, but the screen is not being updated. I have to
    > > scroll
    > > down so that those three cells can no longer be seen on the screen, and
    > > then
    > > scroll right back up again, and then the new values can be seen. Or, I
    > > can
    > > Alt-Tab to a different application, then right back to Excel, and then the
    > > correct cell values are displayed. There are other cells on the same
    > > worksheet that also contain formulas, but do not exhibit the same
    > > behavior.
    > >
    > > I hope I have explained this well enough. Has anyone experienced similar
    > > problems? I would appreciate some advice on how to correct this.
    > >
    > > Thank you.

    >
    >
    >


  4. #4
    Dave Peterson
    Guest

    Re: Screen Refresh

    Maybe...

    Select all the cells on the worksheet
    edit|replace
    what: = (equal sign)
    with: = (equal sign)
    replace all

    Maybe it'll wake up excel???

    Michael H wrote:
    >
    > Hi.
    >
    > I'm using Excel 97 and Windows 2000 SP4. Tools>Options>Calculation is set
    > to Automatic.
    >
    > I have a worksheet on which three cells are giving me a problem. These
    > cells contain formulas dependant on other cells in the same worksheet. It
    > seems that these cells are being updated/calculated when I change the cells
    > on which they depend, but the screen is not being updated. I have to scroll
    > down so that those three cells can no longer be seen on the screen, and then
    > scroll right back up again, and then the new values can be seen. Or, I can
    > Alt-Tab to a different application, then right back to Excel, and then the
    > correct cell values are displayed. There are other cells on the same
    > worksheet that also contain formulas, but do not exhibit the same behavior.
    >
    > I hope I have explained this well enough. Has anyone experienced similar
    > problems? I would appreciate some advice on how to correct this.
    >
    > Thank you.


    --

    Dave Peterson

  5. #5
    Michael H
    Guest

    Re: Screen Refresh

    Hi Dave.

    Thanks for the suggestion. I tried it, but the problem remains. If you (or
    anyone else) have any other suggestions, I'd love to hear them.



    "Dave Peterson" wrote:

    > Maybe...
    >
    > Select all the cells on the worksheet
    > edit|replace
    > what: = (equal sign)
    > with: = (equal sign)
    > replace all
    >
    > Maybe it'll wake up excel???
    >
    > Michael H wrote:
    > >
    > > Hi.
    > >
    > > I'm using Excel 97 and Windows 2000 SP4. Tools>Options>Calculation is set
    > > to Automatic.
    > >
    > > I have a worksheet on which three cells are giving me a problem. These
    > > cells contain formulas dependant on other cells in the same worksheet. It
    > > seems that these cells are being updated/calculated when I change the cells
    > > on which they depend, but the screen is not being updated. I have to scroll
    > > down so that those three cells can no longer be seen on the screen, and then
    > > scroll right back up again, and then the new values can be seen. Or, I can
    > > Alt-Tab to a different application, then right back to Excel, and then the
    > > correct cell values are displayed. There are other cells on the same
    > > worksheet that also contain formulas, but do not exhibit the same behavior.
    > >
    > > I hope I have explained this well enough. Has anyone experienced similar
    > > problems? I would appreciate some advice on how to correct this.
    > >
    > > Thank you.

    >
    > --
    >
    > Dave Peterson
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1