screen corruption

[phancey]

hi,

I cannot track down what is causing my problem. I have a workbook with
numerous tabs. The data on the tabs is put in by macros and include a
number of formulas including VLOOKUPs to a hidden sheet. There are
also conditional formats.

Under certain conditions I get screen leak - i.e the tab I am viewing
is corrupted by bits of another tab(s) seeping through. It is only
cosmetic and if I click away from the tab and go back, everything is
fine.

If I turn off automatic calculation then the corruption only happens
when I do a manual calculation F9.

I originally had a UDF used in my conditional format but removed that
as I had read that may cause some problems. So my conditional formats
tend to be based on things like DATEDIF or in some cases the values of
cells which themselves are formulas like VLOOKUP.

I also had zoom levels at different amounts for different tabs but
changed all those to 100% as I had read that may cause a problem but
still to no avail.

So I have tried to search but not found a solution. Has anyone come
across a similar problem - found a way to fix it?

I am tearing out what little hair I have left! I do not really want to
change all my conditional formatting, or change my formulas on a trial
and error basis if someone knows a solution as that is going to be a
big job.

cheers
Phil

 

[Bill R]

hi,

I cannot track down what is causing my problem. I have a workbook with
numerous tabs. The data on the tabs is put in by macros and include a
number of formulas including VLOOKUPs to a hidden sheet. There are
also conditional formats.

Under certain conditions I get screen leak - i.e the tab I am viewing
is corrupted by bits of another tab(s) seeping through. It is only
cosmetic and if I click away from the tab and go back, everything is
fine.

If I turn off automatic calculation then the corruption only happens
when I do a manual calculation F9.

I originally had a UDF used in my conditional format but removed that
as I had read that may cause some problems. So my conditional formats
tend to be based on things like DATEDIF or in some cases the values of
cells which themselves are formulas like VLOOKUP.

I also had zoom levels at different amounts for different tabs but
changed all those to 100% as I had read that may cause a problem but
still to no avail.

So I have tried to search but not found a solution. Has anyone come
across a similar problem - found a way to fix it?

I am tearing out what little hair I have left! I do not really want to
change all my conditional formatting, or change my formulas on a trial
and error basis if someone knows a solution as that is going to be a
big job.

cheers
Phil

The problem could be corrupted software (Excel), the monitor driver,
graphics card or even the monitor. Can you try your spreadsheet on another
computer? That will, at least test the software, the way it is configured
and the contents of the spreadshet. After that its' a process of
elimination.

Bill R

 

[phancey]

The problem could be corrupted software (Excel), the monitor driver,
graphics card or even the monitor.  Can you try your spreadsheet on another
computer?  That will, at least test the software, the way it is configured
and the contents of the spreadshet.  After that its' a process of
elimination.

Bill R- Hide quoted text -

- Show quoted text -

unfortunately happens on all computers. It is a solution for the
office and I have distributed to a number of users. So it is not any
of those I suspect, though it may possibly be a corrupt workbook (but
only shows up in this scenario?). I could copy and paste to another
workbook but then formatting it all the same is a pain and there is no
clear evidence that this would solve it. I suspect maybe a memory leak
or just slow calculations (vlookup etc) causing the problem but can't
prove it easily. Thought I would check the knowledgebase first in case
someone has had similar experience.

cheers

 

[Gord Dibben]

There have been reports of a bug in a windows update for office 2007
November 10th

Can cause "visual leaking" from one sheet to another, especially when
running VBA

Don't know if it applies in your case but the temporary fix has been to
uninstall the update............KB973593

And wait for a permanent patch to come through.


Gord Dibben MS Excel MVP

 

[phancey]

There have been reports of a bug in a windows update for office 2007
November 10th

Can cause "visual leaking" from one sheet to another, especially when
running VBA

Don't know if it applies in your case but the temporary fix has been to
uninstall the update............KB973593

And wait for a permanent patch to come through.

Gord Dibben  MS Excel MVP













- Show quoted text -

ok, I am actually running Excel 2003 but I will look into this. thanks
for that.

Any other ideas welcome

 

[Gord Dibben]

Same day was an update for 2003 which also is buggy.

KB973475

Uninstall it.


Gord

 

[phancey]

Same day was an update for 2003 which also is buggy.

KB973475

Uninstall it.

Gord







- Show quoted text -

yes thank you - this does indeed seem to have solved the problem