Excel Formulas and Imported Text Files

[robert stables]

Hi, I have an issue with excel in where if I drag a copy
of a formula down to other cells it gives the original
cell answer even though the references are changing
correctly. I have to then click on each cell for the
correct answer to appear. Does anyone know why it is not
updating automatically?

Thanks for any assistance.

 

[PC]

Sounds like the worksheet is set to manual recalculation.
You can calculate using F9 function key or you can set it
to automatic calculation in the Tools|Options|Calculation
menu.

PC