Hi Cindywylie,

I believe the reason you cannot run the macro a second time I suspect, is because sheet1 in your macro has already being used and assigned a pivot table1 as per your code.
You can close the spreadsheet down and open again and re-run, it worked for me!!