LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Vickster3659
 
Posts: n/a
Default VC Problem refreshing pivot table

Hi,
I have a worksheet that gets new data added once per month, using "Month" as
a column. Before I added May data, my pivot table report displayed in the
correct order- Jan, Feb, Mar, Apr, Grand Total. I'm using Office XP.

After adding May data and refreshing the pivot, my pivot table now is
displayed as Jan, Feb, Mar, May, Apr, Grand Total. How do I get May to be
displayed after Apr? The data is pasted into the source worksheet with May
after April.

This does not happen all the time, but is extremely frustrating when it does
because I have to tell the recipient "I don't know why this happens!"
--
Vickster3659
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Pivot Table - Calc Item Problem Scott Excel Worksheet Functions 2 June 2nd 05 01:53 AM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Pivot Table Problem Yandros Excel Worksheet Functions 1 November 25th 04 12:52 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"