Hello,

I have a template that has a vlookup to another sheet in the file. If I put
a number in a cell it will update all the lookup formulas. All of a sudden
it does not work anymore. I have to put the cursor in the cell and hit enter
to update the fields. I have tried F9 and also manual calculations, but it
does not work unless I put the cursor in the cell and hit enter. I have
several lookup fields and it takes time to do this. Also at the bottom of
the task bar it says calculation. which I tried, which wil not go away when I
hit F9. Has anyone had this problem? Does anyone know of a fix for this?
Any help will be really appreciated.

Thank you
--
thank you mac