Hi to everyone.

I noticed a strange behaviour in excel 2007 data tables. It doesn't happen in excel XP/2003. I wonder whether something has changed or perhaps it's a sort of bug. Let's cut to the chase.

I set up a one-way data table that generate (for example) an income statement for 10 companies (in this example I would have the formulas in the leftmost collumn and the name of the 10 companies in the top row). Then in one cell I put a simple formula that sum an item of all ten companies (say EBITDA for example summing all items in a row). The problem is that this cell doesn't get updated (ie it doesn't perform the sum) even if I press F9. The only way to have excel calculate the sum is either to enter the cell and press enter or re-open the file. Very strange.

Any suggestion to solve this ?

PS: sorry for my english

Paolo

Italy