how to define excel pivot range that starts on the nth row?
<p>I know that when selecting A:F as a range in a pivot table,  excel knows  to ignore rows that are not in the usedrange. </p>

<p>i want to skip the first n rows so that the pivot range will be A6:F1000000.</p>

<p>since the range is explicitly defined, I dont believe excel can perform any optimization</p>

<p>do you know what is the right way to skip the first n lines? </p>