any known problems with calculating Excel XP macros in Excel 2000?

R

Robin Milford

I have a large spreadsheet using my own Visual Basic for Excel macros which I
originally wrote in Office 97; I now use Office XP at home and Office 2000 at
work. When I tried running the Office XP version at work under Office 2000 it
caused an error on recalculating. It said it had written an error log but
didn't tell me where. My IT department said there were known
incompatibilites between Office XP and Office 2000 and I should save the
spreadsheet as Office 2000. I can't do that, only Office 97 or 95. I'll try
the Office 97 version tomorrow; in the meantime can anyone throw any light on
this?
 
D

Dave Peterson

I use xl2k at work and xl2002 at home.

xl2002 added some stuff that isn't supported in earlier versions. If I stay
away from that stuff (while coding in xl2002), then I don't have trouble running
it on xl2k.

And if I code in xl2k, I can't remember any problem I've ever had in xl2002.

If you could be more specific, maybe someone else can jump in.
 
R

Robin Milford

Sorry, it's difficult to be more specific as its a complex spreadsheet and
the error message doesn't help. It just said 'Program Error Excel.exe has
generated errors and will be closed by Windows. You will need to restart the
program. An error log is being created.' I tried running it at work today,
and it runs fine on Excel 97, but intermittently stops with the above message
when recalculating under Excel 2000 - not always! OK with Excel XP at home.
As I said, I can't find the error log.
 
D

Dave Peterson

I think I try to eliminate excel (itself) as the cause -- verify that it's a
problem with the workbook.

Did you get the crash when you loaded the workbook or when you started a macro?

I guess either way, I'd do this first:

Start excel in safe mode (macros will be disabled)

close excel
windows start button|Run
excel /safe

file|open your workbook.

If it crashed when you were opening it normally, but it didn't crash this time,
you can read some tips at Chip Pearson's site:

Chip Pearson has some notes to help diagnose startup problems at:
http://www.cpearson.com/excel/StartupErrors.htm

(Maybe cleaning the windows temp folder would help. And sometimes the file that
holds the customized toolbar settings gets corrupted--deleting (or renaming)
that *.xlb file could help.)

And sometimes workbooks get corrupted. In my little experience with corrupted
workbooks, xl2002 is usually the savior that can open the bad workbook--but I've
read posts that say that sometimes xl2k can open files that xl2002+ couldn't.

And you may want to try opening it in another program: OpenOffice
Save it as a new name and see if that helps in excel.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com


Good luck,
 
Top