Excel 2002 Pivot Table: Why reference is not valid ?

M

Mr. Low

Hi,

I wish to create a pivot table from a data table of 8 column X 7760 lines
with proper report headinngs

Surprisingly the Excel returns with error message "Reference is invalid".

May I know why and how to overcome this problem ?

Thanks

Low
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference is not valid for Pivot tables 2
"Reference is not Valid" 0
Pivot Table "Data source reference is not valid" error cause? 1
Pivot table report invalid 0
Excel 2013 Pivot Data Range formula reference problem 0
Pivot Table - Error "Reference Is Not Valid" 0
The PivotTable field name is not valid (error) 1
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ? 3

Top