Thread: Pivot Table Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
  
Posts: 179
Default Pivot Table Help
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