I'm getting an error that doesn't make sense to me.

I have a pivot table that is part of a spreadsheet. I access it through ThisWorkbook so that I should always pull the correct workbook. This should update with the change of a spreadsheet's name (considering I have no control over the end user renaming it).

The data it pulls from is also in the same workbook, but goes by the wrong name because the spreadsheet has been renamed.

How can I correct this in code or as an option on the worksheet?

This causes my spreadsheet to crash when updating my pivot tables by VBA.

Thanks guys.