Excel acting up

  • Thread starter Good Excel Workbooks Now Acting Up
  • Start date
G

Good Excel Workbooks Now Acting Up

Has anyone experienced the following behavior in Excel Workbooks?

We have developed a PM tool (an Excel Workbook using VBA macros) several
years ago. This workbook is used as a template by 30 or so people; and
working properly in excel 2003 & excel 2007 until maybe 2 weeks ago.

About 2-3 weeks ago, one of the users sent a copy of this file to the
office. It was behaving strangely...objects from other worksheets (dtpickers,
formatted cells/ranges of cells) were painted over the active worksheet as we
were working with it (persistent until scrolling down or minimize-maximize
excel window).

I've opened the file to investigate, but since then all my workbooks on my
machine are behaving in the same way. I have this behavior happening on 2 of
my laptops among which I exchanged XLS files.
Also for 4 of my colleagues that had opened this file that had been sent to
us (I’m hearing that is spreading throughout the company) are starting to
have their workbook act in the manner described above; after we have
exchanged and opened the workbook, thinking that it is a "setting" or some
macro failing somewhere.

I uninstalled and reinstalled both office 03 & 07. After this, my workbooks
were working properly (as they were supposed to), this problem was not
occurring anymore. But the behavior reappeared as I opened one of the
workbooks I had opened when I had the funny behavior present.(I did not open
again the original 'bad' file responsible, but another workbook I had on my
machine working fine before this event)

I thought it was behaving as a virus and i posted one of the workbooks to
MMPC. (Microsoft Malware Protection Center)...The first file I submitted they
said is clean for viruses...the second time I posted the original workbook I
received from the user and I still have the "Active Investigation" status for
more than a week w/ no reply yet from Microsoft.
 
G

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
 
R

Roxana

Thank you.
Removing the 2 security updates has solved my problem. I misinterpreting the
symptoms.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top