ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Andmor" wrote in message ...
| for some reason whenever i run a formula down over selected cells the
| information from the first cell is copied down until I save then the cells
| update to the proper information.
| --
| A.