Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Screen Refreshing Anomaly

We are using Excel 2003 SP3 on a network. Observed behavior: In an
apparently random manner, Excel flashes quickly through numerous "broken
images" and flickers, showing pieces and parts of other worksheets that are
open, in no particular pattern, before ultimately stopping and displaying a
broken image. At this point, clicking over to another worksheet, or
scrolling the broken area off the screen, and then returning, will reset the
image. This anomaly possibly occurs when saving a workbook, but not always;
it possibly occurs when deleting or moving Controls on a worksheet, but not
always; it possibly occurs when entering formulas into a cell, but not
always. It doesn't seem to matter what workbook is open, and it's doesn't
always refresh incorrectly. It seems random, but I'm sure there's a pattern
there, somwhere - we just haven't identified it yet.

In trying to troubleshoot the cause, we believe it is somehow related to the
calculation of the worksheet. Pressing F9 or Ctrl/Shift/Alt F9 will cause
the anomaly every time. We've looked at the macros in PERSONAL.XLS and
everything seems to be in order. Two of us use the same macros and setup,
but this problem is only occurring on one computer. The problem began
suddenly and has been ongoing for a few weeks now.

Anyone have any ideas what might be causing this, or where we should look to
further troubleshoot?

Thanks in advance,
--
Susan
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Screen Refreshing Anomaly

Some additional information:

We've discovered that the situation only occurs where we have added
hyperlinks internal to the workbook. It seems that the screen is doing
"Application Screen Updating" during the recalculation phase.
--
Susan


"SueDot" wrote:

We are using Excel 2003 SP3 on a network. Observed behavior: In an
apparently random manner, Excel flashes quickly through numerous "broken
images" and flickers, showing pieces and parts of other worksheets that are
open, in no particular pattern, before ultimately stopping and displaying a
broken image. At this point, clicking over to another worksheet, or
scrolling the broken area off the screen, and then returning, will reset the
image. This anomaly possibly occurs when saving a workbook, but not always;
it possibly occurs when deleting or moving Controls on a worksheet, but not
always; it possibly occurs when entering formulas into a cell, but not
always. It doesn't seem to matter what workbook is open, and it's doesn't
always refresh incorrectly. It seems random, but I'm sure there's a pattern
there, somwhere - we just haven't identified it yet.

In trying to troubleshoot the cause, we believe it is somehow related to the
calculation of the worksheet. Pressing F9 or Ctrl/Shift/Alt F9 will cause
the anomaly every time. We've looked at the macros in PERSONAL.XLS and
everything seems to be in order. Two of us use the same macros and setup,
but this problem is only occurring on one computer. The problem began
suddenly and has been ongoing for a few weeks now.

Anyone have any ideas what might be causing this, or where we should look to
further troubleshoot?

Thanks in advance,
--
Susan

Reply
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
Top N Pivot Anomaly PatK Excel Discussion (Misc queries) 0 April 10th 09 10:14 PM
Combo Box Anomaly Garyw Excel Discussion (Misc queries) 2 June 23rd 08 09:03 PM
Date anomaly HaoHoaMastercard Excel Discussion (Misc queries) 4 October 11th 07 08:05 PM
Sort anomaly supersheet Excel Worksheet Functions 0 August 28th 07 06:57 PM
VLOOKUP Anomaly Tosca Excel Worksheet Functions 6 May 8th 05 09:08 AM


All times are GMT +1. The time now is 05:48 AM.

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"