I have an Excel file that contains multiple pages. All of these pages
require a range of data that includes the most recent 10 years plus prior
years. For example, in cell A1, I enter "Prior Years". In A2, I enter 1995,
in A3, 1996, in A4, 1997, etc. I want to be able to build this data range on
one page and then on subsequent pages use this range name so I only have to
change the dates in one location. I have created the initial range of data
and assigned it a range name. When I go to the other pages, I select the
appropriate cell and type '=RangeName' (not including the tick marks. When I
do that, I don't get the expected dates. Instead it displays, "=RangeName".
What do I need to do to get the desired results?

Make sure the cells are not formatted as Text.

If it is, format the cells as General, then select the cells, hit F2 (to edit
that cell) and ctrl-shift-enter to tell excel to reevaluate the array formula.
(You do select multiple cells when you're entering this range name, right?)

Shelter Pat wrote:

I have an Excel file that contains multiple pages. All of these pages
require a range of data that includes the most recent 10 years plus prior
years. For example, in cell A1, I enter "Prior Years". In A2, I enter 1995,
in A3, 1996, in A4, 1997, etc. I want to be able to build this data range on
one page and then on subsequent pages use this range name so I only have to
change the dates in one location. I have created the initial range of data
and assigned it a range name. When I go to the other pages, I select the
appropriate cell and type '=RangeName' (not including the tick marks. When I
do that, I don't get the expected dates. Instead it displays, "=RangeName".
What do I need to do to get the desired results?

--

Dave Peterson