Issue while inserting pivot Tables in Excel 2003

[Clemens]

Hi friends,

I am creating a pivot table from another worksheet which is having some range. Whenever i try to enter the range to use it , i am getting an message which says me reference not valid.I don't know what is wrong can anyone help me out with this issue.

[Crona]

Sure i will help you out with this try to follow the below steps i am sure this would solve your problem.

1. Open your Excel worksheet. Under Data option , select PivotTable in the dropdown menu.
   
   
2. In the PivotTable Wizard box, select the data you want to analyze by clicking on the corresponding radio buttons. Click Next.
   
   
3. In the next screen, select the range you want to analyze. To define the range, drag your left mouse over the cells you want sorted. Click Next.
   
   
4. In the final screen, select whether you want the pivot table to appear in a new worksheet or an existing one.
   
   
5. Click Finish to insert the pivot table. Save your work.

[Clemens]

I try to do that but still getting same message as reference not valid.

[Glenny]

I was also getting similar type of issue because i was using a named range from an external workbook, and i have to include the workbook name in my formula and likely need to have that workbook open after which i didn't got the message hope you would also have done same mistake.