Range problem in Pivot table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ravi - 28 May 2008 07:24 GMT

This is the problem I have with few excel sheets but not with all. When I
select a range of cells including the Column headers and go for Data - >
Pivot table and Pivot Chart report ... and click on Next , I can see
"Database" in the Range field rather than the range (example : $A$1:$B$7).
Could someone help.

Reply to this Message

DILipandey - 28 May 2008 08:11 GMT

Hi Ravi,

You have not mentioned which version of excel you are using. One possiblity
might be that the range you are selecting, already has the name defined as
"Database". Sometimes excel, itself defines names such as "data" or
"database" by default, on which I am not very sure.

Signature

Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
dilipandey@yahoo.com
dilipandey@gmail.com
New Delhi, India

> This is the problem I have with few excel sheets but not with all. When I
> select a range of cells including the Column headers and go for Data - >
> Pivot table and Pivot Chart report ... and click on Next , I can see
> "Database" in the Range field rather than the range (example : $A$1:$B$7).
> Could someone help.

Reply to this Message

Ravi - 28 May 2008 08:32 GMT

Thanks Dilip,
I am using Office 2003 Standard edition. If excel has defined that name,
then is there a way to delete that name? Please suggest.
Regards
Ravi

> Hi Ravi,
>
[quoted text clipped - 8 lines]
> > "Database" in the Range field rather than the range (example : $A$1:$B$7).
> > Could someone help.

Reply to this Message

Andrea Jones - 28 May 2008 09:43 GMT

Click on Insert -> Name -> Define and you will see a list of range names. If
'Database' is in the list then you can select it and delete it if you no
longer need it (although it may be used by another function). Leaving the
range name there won't make any difference to you being able to select the
cells and use them for a pivot table.

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

> Thanks Dilip,
> I am using Office 2003 Standard edition. If excel has defined that name,
[quoted text clipped - 14 lines]
> > > "Database" in the Range field rather than the range (example : $A$1:$B$7).
> > > Could someone help.

Reply to this Message

Ravi - 28 May 2008 10:10 GMT

Thanks a lot Andrea, it worked out.
Cheers , Ravi

> Click on Insert -> Name -> Define and you will see a list of range names. If
> 'Database' is in the list then you can select it and delete it if you no
[quoted text clipped - 24 lines]
> > > > "Database" in the Range field rather than the range (example : $A$1:$B$7).
> > > > Could someone help.

Reply to this Message