On Apr 27, 10:45*pm, Paul S wrote:
I have stored an excel 2003 version of the file on the
following website
http://www.filedropper.com/exampleibnd2excel2003.

FYI, I cannot open that file successfully. First, it was saved as an
XL2007 xlsm file, not as an "XL2003" xls file. Second, the Office
conversion utility or XL2003 stumbles over a fatal internal error.

No matter: I do not need to look at the entire Excel file.

If you want me to look at the macros, you can simply copy-and-paste
the text to Notepad and upload the txt file to a file-sharing website.

Paul wrote:
I have capped the last row of all named ranges to 65000

And yet I still get an error to the effect of: "This workbook
contains data in cells outside of the row and column limit of the
selected file format. Data beyond 256 (IV) columns by 65,536 rows will
not be saved. Formula references to data in this region will return a
#REF! error."

Go figure!

Paul wrote:
I hope the pivot now works.

It is my (weak) understanding that no XL2007 pivot table is compatible
with XL2003. At least, that is the sense that I get from the
"compatibility report" in the previous version. It states:

"A PivotTable style is applied to a PivotTable in this workbook.
PivotTable style formatting cannot be displayed in earlier versions of
Excel."

"A PivotTable in this workbook will not work in versions prior to
Excel 2007. Only PivotTables that are created in Compatibility Mode
will work in earlier versions of Excel."