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?