Copy formulas - strange things happens

P

Pop

I have a problem I have never seen before - I have a row of numbers that I
want to divide by 1000 - I do as I usually do +CELL/1000 - when I drag to
copy the formula down to the next cells I get the same number in all cells -
the reference looks OK - If I do it "manually" in all cells, it works ....

Does anybody have a clou on this ?
 
J

Jason Morin

Make sure your wb is not set to manual calculation. Check
under Tools > Options > Calculation tab.

HTH
Jason
Atlanta, GA
 

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

Copying formulas 1
Formulas won't increment when dragging to adjacent cells? 3
Divide By 6
copy formulas over merged cells 2
Automatically Pulling Cells from Different Tabs and Files 1
Copy paste data from a column to a row 0
Cell Reference & formula 5
Filling Formulas 2

Top