Pivot table ranges

[Dimps]

I have a file which includes a Pivot Table I created a year ago. The data range has now increased from 10,000 rows to 12, 000 rows ... but when I try to change the source range to the higher number the relevant cell in the Pivot is "greyed out".

Please advise how I can change this, or do I have to create a new Pivot Table?

[SuperTech]

Thank you for posting.

Please share your file so we can investigate the issue further.

If your file is confidential, you can send it to forum[at]softmaker.com with a link to this post.