|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 23rd, 2005, 11:08 AM
|
|||
|
|||
restrict data in a pivottable
Hi,
how can I resrtict the column and row values in a pivot table. for example of "date" is my column heading, and the base data has dates from 2004 and 2005, can I force the date "drop down" to only include those dates from 2005 (so you could never have the option of clicking a 2004 date) thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
| Import data to pivottable | MJP | General Discussion | 1 | November 18th, 2004 12:46 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
| Pivot Tables compatibility - 97 and 2000 ? | Clarence Crow | Worksheet Functions | 5 | January 5th, 2004 05:48 PM |
Threaded Mode