Solved Compatibility of an Excel spreadsheet.

January 7, 2013 at 20:24:33
Specs: Windows XP
Shouldn't an Excel spreadsheet ( including the Visual Basic portion) that was produced with Excel 97 also work in Exel XP.
When I try this, I get this error message -

Run-time error 1004
Calculate method of range class failed

The spreadsheet works fine in Excel 97 but, the Visual Basic part does not work in Excel XP.
What is causing this?

See More: Compatibility of an Excel spreadsheet.

January 8, 2013 at 03:13:36
There was a big change between XP/2003 and 2007 versions so it isn't too surprising that something created in 2007 won't work in the XP/2003 version. There's unlikely to be a Microsoft workaround as it's not to their benefit to make everything backward compatible and they usually cite security issues being the reason. If the user does not want to upgrade to a newer version of Excel, have you tried opening it in one of the free Office suites like OpenOffice & see if it works?

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

Report •

January 8, 2013 at 04:52:54
✔ Best Answer
johnr: The Op was talking about 97 vs. 2003, not 2007 vs. 2003.


Without knowing what line caused the error there's not much we can do to help. The next time you get the error, click the Debug button and note which line is highlighted.

Then, after clicking the blue line at the bottom of this post and reading the instructions found via that link, post the code and tell us which line is causing the error.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question