Trouble Using Pivot Table off a DNR

Originally Posted by Ron Coderre

Your Dynamic Named Range should be defined as:

Names in workbook: DNR1
Refers to: =OFFSET(Data!$A$1,,,COUNTA(Data!$A:$A),72)

Does that help?

Yes!!!

Thanks. You're a lifesaver.

But what does the "72" mean at the end of the formula? I thought it was supposed to represent the number of columns in the database.