Annoying copy down value error?

djalexr

New Member
Joined
Jan 14, 2011
Messages
33
Hi all,

I've recently started getting this really annoying issue which is messing up my vlookups and other things

When copying down a forumla, excel does copy the formula but the value which shows clearly isn't what is shown in the formula - if you see this image, I have simply done G1*1 and copied it down - you can clearly see the entire column is showing 9466 where it should mirror column G ... you can also see i've highlighted cell H2 clearly says G2*1 which should be 104*1 so how on earth is it showing 9466?



Any help much appreciated! It never used to do this!

Thanks

Alex
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
It sounds like you have Formulas set to Manual Calculation. What happens if you hit F9?
 

djalexr

New Member
Joined
Jan 14, 2011
Messages
33
great, that did seem to help! the only thing is it keeps reverting and I keep needing to press F9 to get it to adjust properly - do you know how to change this permanently?
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Goto File-->Options-->Formulas-->Set Calculation to Automatic.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,561
Messages
5,596,849
Members
414,107
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top