I have copy/pasted some workbooks from lotus into Excel 2003
(because excel do not read *.123-files)

There are multiple spreadsheets in each workbook. All looks ok after some
cleaning up,the formulas are not copied -but that is ok,having the numbers is
enough for me to write new formulas.

This is very simple spreadsheets, with only some sum-formulas and no
connections between the sheets. I have formatted the cells containing numbers
correctly (I think..)

But it is now the odd thing happens; in the first spreadsheet the new
formulas work fine. But in the next spreadsheet (in the same workbook) the
formula returns 0.

All help is much appreciated :-)