Excel 2007 pivot table data is truncated

[brad]

When opening a file created in a previous version, the pivot table data will
only use the first 16,384 lines of data which used to be a very old
limitation. Does anybody know how to fix this so I don't have to manually
redefine all of my pivot table data ranges in all of my workbooks?

 

[Teethless mama]

You need to create a name range. Select your range then click on Insert >
Name > Define > create a name for your range