Excel takes the calculation mode of the first workbook opened during a
session and applies that mode to all subsequent workbooks opened in that
session.

i.e. ignores which calc mode the subsequent workbook had when saved.


Gord Dibben MS Excel MVP


On Wed, 17 Dec 2008 11:46:01 -0800, J. K. Parks <J. K.
wrote:

Thanks much...I took my Options for granted since I didn't make a change.
Are there any usual suspects which would have caused this change. As
indicated in my plea below, it was working fine up til now...

"Bernie Deitrick" wrote:

Change your calculation mode to automatic - Tools / Options / Calculation tab, click Automatic.

HTH,
Bernie
MS Excel MVP


"J. K. Parks" <J. K. wrote in message
...
What if this doesn't work. It used to, but now when I drag, the copy cell
value is returned to all pasted cells, even though the search value should
return a different value. I can retype the cell from scratch and it works,
but no matter which copy technique I use, the initial cell's return value is
defaulted to all pasted cells.


"Jerry W. Lewis" wrote:

A preceding $ indicates a part of the address to hold constant, as in
$A1, A$1, or $A$1 to hold the column, row, or both constant.

Jerry

Martc wrote:

I want to copy a VLOOKUP formula down down the worksheet. When I use the drag
handle it increments 2 values ie A1, A2, A3 etc. I want it to increment one
of the values but i want the other to stay the same.

How do I do it?? Please help

Mart