View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shawna Shawna is offline
external usenet poster
 
Posts: 20
Default adding more data to pivot table.

I add data to an exsisting pivot table every day and month. When I added a
new month, it added the new data to the bottom of the pivot table instead of
adding it to the correct column. example:

Jan Feb Mar Apr
John Smith 5 2 6
April Jones 2 1 4 3
John Smith 2
B. Smith 3
Why does it add below and not at top under the month? I've tried the
options, doesn't fix it.