Problem but no error - DA

[DA]

Lately, I have noticed that a big file I modified caused EXCEL to
produce an error that EXCEL has encountered a problem and needs to
close. When I ask it to recover the file, it takes nary a second or
two to do its thing. When the file shows up, a second or two later,
and I right click to "show repairs", it says that no errors were
detected and no repairs were necessary.

Is this yet another known Microsoft bug in EXCEL 2003? Has anyone
else seen this?

Thanks
DA

 

[JLGWhiz]

http://support.microsoft.com/kb/832334

 

[DA]

The first URL is just generic and it says it was hixed by a hotfix in
2004, so that's not my problem. The second one does not work.

But thanks for trying!

I see, upon googling, that there are lots of referecnes to macros and
such, particularly ones that start when you opne a file. To my
knowledge, mine deosn't, It does have such a macro but I had
commented out the subroutine nmae and every rows but one. I found one
line in the workbook open macro that I did not comment out because it
was a continutation of a prior line, so I figured I didn't need to
comment it out. But, after doing that and resaving, it seems Ok for
now. I'm not sure there will be a magic answer for me.

I just wonder why it would say there is a problem and, then after I
ask it to fix it, it would say there was nothing to fix. Classic
Microsoft, I guess!

Still open for any explanations, even though I am probably Ok for now.

 

[Patrick Molloy]

it sounds like youe excel workbook may have been corrupted. Try
http://www.appspro.com/Utilities/CodeCleaner.htm
from Rob Bovey