Maybe:

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kathyrn" wrote in message ...
|I need to know when I do a vlookup its not pasting the formula but when I go
| to save the spreed sheet it changes the fields to correct material descripion.