Pivot Table Help
 

Good Morning


I have a pivot table set up and all is ok
i have set up a macro to copy the data in the pivot table and to paste it
sumwhere else and to sort it

all is good, but when i save the spreadsheet and close it down and reopen it
and run the macro the pivot table shrinks down to 2 rows and 2 colums

how do i get my data back on show


Can anyone help


Thanks in Advance



Steve