Hi,
Why the pivot table always creating in third row in the new worksheet? Is there any way to change the default Range?
Is there any specific reason?



I'm using ms office 2013

Please post a sample sheet showing what goes wrong ( click Go advanced - Manage attachments) Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I don't think there is any way to change this (maybe apart from VBA). Most likely this is what Microsoft calls By Design.
And I guess it is meant to make room for the filter option. If you create a pivot table in a new worksheet and you apply a filter, that filter will appear in cell A1.

When creating a new pivot table you can of course check Existing worksheet and then in the Location field specify A1 (for instance) in a blank worksheet. However, if you now apply filter you will see that the pivot table is removed so that it starts in A3.