I recorded a macro using the pivot table, while recording the macro i tried to assign the pivot table to a permanent worksheet. but when i run the macro again, i get an error. i want the pivot table to appear in the a specified worksheet everytime i run the macro. is this possible? thanks!