Range problem in Pivot table

[Ravi]

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.

 

[DILipandey]

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.

--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Ravi]

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

 

[Andrea Jones]

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

 

[Ravi]

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