I have put a spreadsheet together using Excel 2000. A friend is trying to use
it with Excel 2002 and experiences a problem that I cannot reproduce in Excel
2000.
Cell E3 is a persons name. Cell F3 contains the formula '=E3' to auto fill
the cell. (If the name is not the correct one it is overwritten)
If friend copies the formula in F3 to F4 it copies the formula as an
absolute so that it is looking at E3 rather than E4.
He is not copying an absolute. He either drags the formula down or copy &
pastes.

I can't understand what is happening but presume that his version works
differently to mine, there is some optional setting that needs to be clicked
on or off.
Any help gratefully received - iotherwise I am going to have to upgrade!!

It sure sounds like he's not copying, but cutting.

Is that formula still in F3 when he's done?

If it is, then ignore my response.

Dave the slaphead wrote:

I have put a spreadsheet together using Excel 2000. A friend is trying to use
it with Excel 2002 and experiences a problem that I cannot reproduce in Excel
2000.
Cell E3 is a persons name. Cell F3 contains the formula '=E3' to auto fill
the cell. (If the name is not the correct one it is overwritten)
If friend copies the formula in F3 to F4 it copies the formula as an
absolute so that it is looking at E3 rather than E4.
He is not copying an absolute. He either drags the formula down or copy &
pastes.

I can't understand what is happening but presume that his version works
differently to mine, there is some optional setting that needs to be clicked
on or off.
Any help gratefully received - iotherwise I am going to have to upgrade!!

--

Dave Peterson

On Wed, 16 Feb 2005 11:49:09 -0800, "Dave the slaphead" <Dave the
wrote:

I have put a spreadsheet together using Excel 2000. A friend is trying to use
it with Excel 2002 and experiences a problem that I cannot reproduce in Excel
2000.
Cell E3 is a persons name. Cell F3 contains the formula '=E3' to auto fill
the cell. (If the name is not the correct one it is overwritten)
If friend copies the formula in F3 to F4 it copies the formula as an
absolute so that it is looking at E3 rather than E4.
He is not copying an absolute. He either drags the formula down or copy &
pastes.

I can't understand what is happening but presume that his version works
differently to mine, there is some optional setting that needs to be clicked
on or off.
Any help gratefully received - iotherwise I am going to have to upgrade!!

Perhaps your friend is moving the formula, rather than copying it. At least in
2002, if you move the formula the references do not change. They only change
if you copy/paste.


--ron

I discovered that he had his calculation options set to 'manual'. Problem
solved, but thanks for your responses.

"Dave the slaphead" wrote:

I have put a spreadsheet together using Excel 2000. A friend is trying to use
it with Excel 2002 and experiences a problem that I cannot reproduce in Excel
2000.
Cell E3 is a persons name. Cell F3 contains the formula '=E3' to auto fill
the cell. (If the name is not the correct one it is overwritten)
If friend copies the formula in F3 to F4 it copies the formula as an
absolute so that it is looking at E3 rather than E4.
He is not copying an absolute. He either drags the formula down or copy &
pastes.

I can't understand what is happening but presume that his version works
differently to mine, there is some optional setting that needs to be clicked
on or off.
Any help gratefully received - iotherwise I am going to have to upgrade!!