Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

creating pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating a pivot table

Creating a pivot table

ResolvedVersion 2007

Jane has attended:
Excel Advanced course

Creating a pivot table

I'm trying to create a pivot table. I've selected my data range but I'm getting 'Data source reference is not valid' as a pop up. What am I doing wrong?

RE: Creating a pivot table

Hello Jane,

You might be getting the error ‘Data Source Reference is not valid’ because you might not be selecting the correct range before clicking on Pivot table.

Otherwise, if you have any empty cells or any graphics in the range you have selected, you may also get this error message.

I am assuming your data columns all have headings.

I hope this solves your problem.

Kind regards
Marius Barnard
Best STL

RE: Creating a pivot table

Yep those were all the things that I thought of. There are no blank columns and I've tried making the header row bold or not to pick it out - all to no avail. The data is exported from a web-based bit of software, but I can see nothing about the data that should make it problematic.

Is there a facility for me to send the sheet to you so you can have a look? I'm sure I must be missing something completely basic, but I can't work out what it is.

Jane

RE: Creating a pivot table

Hi Jane,

Sure, you can email me your spreadsheet to marius@stl-training.co.uk

Kind regards
Marius

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.