| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table Help
|
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Help
If you post the code that you created, someone may be able to help.
Additional details, such as the pivot table source (Excel, Access?), and which version of Excel you're using, would also help. Debby Bunce wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Help
After having a mess around iv sorted out he problem
thanks again steve "Debra Dalgleish" wrote in message ... If you post the code that you created, someone may be able to help. Additional details, such as the pivot table source (Excel, Access?), and which version of Excel you're using, would also help. Debby Bunce wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Linear Mode
