Pressing CtrlAltF9 in Excel should recalculate the whole spreadsheet automatically.
I have to set the export preferences to Excel 97 + (Monarch V8) format in Export and Clipboard Options.
If I don't use this format, the cells related to the import does not calculate. I have to do a F2 on the cell to be calculated. When I have more than 1000 cells to recalculate manually, I better export in V8 format.
But I would just like to use the new features of V9.
Thanks for helping me! [/b][/quote]