PivotCaches.add Error 5 - 2003 to 2010 Macros

I have a 2003 Excel xls file that I am trying to run in Excel 2010. I first saved the file as a xlsm and added the directory as trusted in Trust Center. I am getting an error code in the red. Note: If I change the PivotTableVersion to 12, it still gives me the same error. Code is below. Thank you in advance for your help!

Please Login or Register  to view this content.