The loop creates a new workbook, so each pivot table is in it's own Excel
workbook.

I put in a line to close the workbook each time in the loop, and now the
program is continuing on with no troubles.

So, it's something about the connection to the previous pivot that's causing
the next one to fail?