Thread: Pivot Table Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Debby Bunce Debby Bunce is offline
external usenet poster
  
Posts: 23
Default Pivot Table Help
just tell me what i need to do if thats ok


steve



"Muhammed Rafeek M" wrote in
message ...
can u pls send your file to me: . i hope, i can help
you

"Debby Bunce" wrote:

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









Reply With QuoteReply With Quote