Prev: Print Area 2003 and 2007
Next: How can I set up a pop-up calendar for 2010 in Excel?
From: Jega-OZ on 14 Jan 2010 00:27
when I create a formula using cells from a different workbook, excel
automatically uses absolute cell reference. Is there a setting that could
change this to use relative cell refrence?
From: Dave Peterson on 14 Jan 2010 09:09
I've never seen one. That's the way excel works.

If you select the formula (or parts of the formula) in the formula bar, you can
hit F4 to cycle through 4 relative/absolulte addresses.

Jega-OZ wrote:
>
> when I create a formula using cells from a different workbook, excel
> automatically uses absolute cell reference. Is there a setting that could
> change this to use relative cell refrence?

--

Dave Peterson
 | 
Pages: 1
Prev: Print Area 2003 and 2007
Next: How can I set up a pop-up calendar for 2010 in Excel?