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
Bookmarks