Copy and Paste Formulas

A

Alfred Lavallee

I have a spreadsheet that suddenly started to fail when
adding or subtracting columns (ie: =L4-K4)and copying and
pasting in cells below. It shows the correct formulas in
the cells below but gives the same result as the cell
being copied from. If I put the correct formula in (ie:
=L5-K5) it works correctly.

Any ideas what's happening? It does it in other files as
well.
 
A

Andy B

Hi

It might be worth checking if Calculation is set to manual. If you hit F9,
do the values become correct?
Go to Tools / Options / Calculation and select Automatic
 
A

Alfred Lavallee

Andy,
Thanks a bunch. That solved my problem. Must have
changed it and didn't realize what I was doing.
 
A

Andy B

Well, the status of the calculation mode is determined by the first book you
open during the Excel session. So the first book you opened during this
session must have had calc set to manual.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Excel help needed: Skipping cell without skipping cell reference 1
TODAY() issues 6
Automatically copy formula in column when adding new row.... 2
Hide columns based on row values 2
How do I ensure formulas automatically calculate after pasting 1
drag formula down from columns that go acros 3
Excel copy and paste 1

Top