Pivot Tables

Hi Claire

Thank you for your question - glad you got it all sorted.

Sometimes Excel is unsure of the range of cells to use as the source for your pivot table. Make sure you have clicked into the source data before choosing to pivot. Even better would be to highlight the range of cells including labels then start the pivot process (although most times this is not necessary).

I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew