Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 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 (Im 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel acting up
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 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 (Im 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel acting weird | Excel Discussion (Misc queries) | |||
Excel file acting odd | Excel Discussion (Misc queries) | |||
Tab Key acting up in Excel 2003 | Excel Discussion (Misc queries) | |||
EXCEL 2007 acting up | New Users to Excel | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) |