When I copy a formula to other cells, it displays the data ....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in the field I copied from. I did NOT use absolute in the formula. If I
double click on the cell with the incorrect data then press enter, the data
is updated and correct. What is going on here, I have never had this happen
before?

Thanks in advance to any answers...
 
Hi
goto 'Tools - options - Calculate' and enable 'Automatic Calculation'
 
you need to turn caculation on to automatic. go to tools, options
calculation and select automatic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Formula copying error 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel keeps copying formulas into other cells!! 2
copying a formula 1
copy and paste the cell with formula ="1" 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Copying a range of data without adjusting formulas 16

Back
Top