Excel Formulas and Imported Text Files

  • Thread starter Thread starter robert stables
  • Start date Start date
R

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.
 
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
 
Back
Top