Excel 2003 hangs calculating cells from a Excel XP created Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Bates - 12 Apr 2007 16:00 GMT

I have an excel document that was created in Excel XP, and it opens fine in
Excel XP. When I try to open it in Excel 2003, it tries to go thru
'calculating cells'. It hangs at 5% on a mid range laptop and 25% on a high
end desktop. Is there a fomula converter or something I cna run on the file
to get it to open in Excel 2003?

James Bates

Reply to this Message

Jim Rech - 12 Apr 2007 18:14 GMT

Excel 2002 and 2003 use the same file format so it's not an issue of
converting formulas. Rather it would seem to be something it 2003's
configuration. In your place I'd see what happens when the workbook is
opened in a 'pure' Excel configuration. From Start->Run enter "Excel.exe
/s" (no quotes, there is a space before the slash).

Signature

Jim

|I have an excel document that was created in Excel XP, and it opens fine in
| Excel XP. When I try to open it in Excel 2003, it tries to go thru
[quoted text clipped - 3 lines]
|
| James Bates

Reply to this Message

ed@excelhelp.us - 12 Apr 2007 20:03 GMT

James,

Maybe Manual Recalculation is on in Excel XP and not in 2003. Maybe
you will receive the same response in XP if you put Auto Recalc on.

Regards,
Eddie
http://ExcelHelp.us

Reply to this Message

Rate this thread: