Menu

Pivot Table Help

Search this Thread

Prev

Previous Post

Next Post

Next

#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

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Top 5 plus Other in Pivot table	almpk	Excel Worksheet Functions	1	July 19th 06 10:29 PM
Derived Columns in Pivot Table	sa02000	Excel Discussion (Misc queries)	1	February 8th 06 07:18 PM
Using a Pivot Table Calculated Field to get a Unique Count	Mike Struckman	Excel Worksheet Functions	1	November 22nd 05 05:32 PM
Pivot -- want to use Max and Sum in same table	Dave	Excel Worksheet Functions	1	July 13th 05 04:37 AM
how to delete/clean out the row list in pivot table	johnÂ²	Excel Worksheet Functions	1	May 26th 05 04:56 AM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement