OK I've got a headache from this and its driving me crazy.
On my old computer, when I referenced another cell by pressing = then
selecting the cell it always inserted the cell reference as relative.

Then I changed jobs and had to move from Excel 2007 back to 2003 )-; and
found that when reference a cell within the same workbook it inserts it as
relative but if I link to a cell in another workbook its automatically
absolute. I thought this must be just a 2003 THING!

But I was merrily working away just then and accidently pressed ctrl +
Something!! and now when I reference a cell on a different worksheet but
within the same workbook it now inserts an absolute reference and only if I
am referencing a cell on the same sheets its relative. As I mostly need to
use relative and if I want to use absolute I usually name the cell this is
INCREDIBLY annoying. Im spending an awful lot of time pressing the F4 button
which I don't like (hence the headache).

Can some one please help me before I start hitting my head against the wall.

That's the default behaviour in xl2003, AFAIK. So I don't think that you
accidentally threw any settings/switches on anywhere.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Karen" wrote:
OK I've got a headache from this and its driving me crazy.
On my old computer, when I referenced another cell by pressing = then
selecting the cell it always inserted the cell reference as relative.

Then I changed jobs and had to move from Excel 2007 back to 2003 )-; and
found that when reference a cell within the same workbook it inserts it as
relative but if I link to a cell in another workbook its automatically
absolute. I thought this must be just a 2003 THING!

But I was merrily working away just then and accidently pressed ctrl +
Something!! and now when I reference a cell on a different worksheet but
within the same workbook it now inserts an absolute reference and only if I
am referencing a cell on the same sheets its relative. As I mostly need to
use relative and if I want to use absolute I usually name the cell this is
INCREDIBLY annoying. Im spending an awful lot of time pressing the F4 button
which I don't like (hence the headache).

Can some one please help me before I start hitting my head against the wall.