Excel 2003 hangs calculating cells from a Excel XP created Document

[James Bates]

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

 

[Jim Rech]

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).

--
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
| '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

 

[ed]

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