When I copy down into the next cell the formula changes correctly.

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

Guest

When I copy down into the next cell the formula changes correctly however the
result keeps reading from the line I copied from. It is not an absolute cell.
The formula is correct. If I delete the result and type the formula manually
into the cell it works. Why would this be - Is there a button I need to tick
off? It only seems to happen on my computer
 
Calculation is probably set to manual. To change it, choose Tools>Options.
 
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

Formula copying error 3
Why did auto calculate suddenly change to manual calcu... 4
Formula stopped working 3
Copying a cell down a column 5
Copying concatenate not returning correct cell information 6
I copy a formula and the results copy from the original cell 1
Copy and Paste in Excel, copies cell and formula, but shows same v 3
pasting formulas 2

Back
Top