Excel acting up

  • Follow


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.

0
Reply Utf 12/1/2009 8:25:01 PM

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

On Tue, 1 Dec 2009 12:25:01 -0800, Good Excel Workbooks Now Acting Up <Good
Excel Workbooks Now Acting Up@discussions.microsoft.com> wrote:

>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.

0
Reply Gord 12/1/2009 8:38:54 PM


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

"Gord Dibben" wrote:

> 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
> 
> On Tue, 1 Dec 2009 12:25:01 -0800, Good Excel Workbooks Now Acting Up <Good
> Excel Workbooks Now Acting Up@discussions.microsoft.com> wrote:
> 
> >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.
> 
> .
> 
0
Reply Utf 12/1/2009 11:02:01 PM

2 Replies
263 Views

(page loaded in 0.019 seconds)


Reply: