Pivot Table Range

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

I'm trying to make sense of another person's Excel 2007 pivot tables
after they left the company. They were a guru. And I just got
hired. Now, the problem is that I know how to see the range to figure
out were the data is at but he didn't put a RANGE.

problem: No range. It just shows a name.

Example:
Go to pivot table. click options. Change data source.
Box labeled "Change PivotTable Data Source" pops up.
Table/Range: userTyrone

I can see the dotted line around all of the data. Then Col A and B
are frozen and a dotted line is on the right side of Col B.

Is that possible?
How can I see the range?

Thanks a million,
Ty
 
I'm trying to make sense of another person's Excel 2007 pivot tables
after they left the company.  They were a guru.  And I just got
hired.  Now, the problem is that I know how to see the range to figure
out were the data is at but he didn't put a RANGE.

problem:  No range.  It just shows a name.

Example:
Go to pivot table.  click options. Change data source.
Box labeled "Change PivotTable Data Source" pops up.
Table/Range: userTyrone

I can see the dotted line around all of the data.  Then Col A and B
are frozen and a dotted line is on the right side of Col B.

Is that possible?
How can I see the range?

Thanks a million,
Ty
Click to expand...

From the main menu go to 'Insert>Name>Define..' and you should see a
list of 'named ranges' - you should be able to identify what the range
is from there. There should be one called 'userTyrone' in the list.

HTH
Matt
http://2toria.com
http://teachr.blogspot.com
 
Tyrone had set up a Name for the pivot data range. A Name is actually a
formula that refers to a range of cells or a value, which you can use in
formulas just like a cell address. You would use a Name if the data
range is dynamic in nature.

If you type "userTyrone" into the name box (to the left of the formula
bar) and hit Enter, this Name will be selected. You can see the
definition of the Name by opening the Name dialog. The shortcut is Ctrl+F3.

Read more about Names at:

Defined Names
http://www.cpearson.com/excel/DefinedNames.aspx

- Jon
 
Back
Top