Prev Previous Post   Next Post Next
  #1   Report Post  
Michael H
 
Posts: n/a
Default Screen Refresh

Hi.

I'm using Excel 97 and Windows 2000 SP4. ToolsOptionsCalculation 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make a splash screen appear first Mark Stephens Charts and Charting in Excel 1 August 15th 06 01:01 AM
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Discussion (Misc queries) 5 October 26th 05 10:10 PM
Hyperlink Screen Tips not cross platform Randy Klein Excel Discussion (Misc queries) 0 October 12th 05 08:29 AM
Refresh Imported Data - Does the Excel file have to be open? tinkertoy Excel Discussion (Misc queries) 0 June 23rd 05 07:51 PM
How do I move the current cell to the top of the screen? mad.cow Excel Discussion (Misc queries) 6 May 29th 05 05:35 AM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"