As Dave Peterson said, you can't put text fields into the data area as text.

Perhaps you could use DataFilterAutoFilter instead, and filter by year
and month, to see the scheduled names for a specific period.

Or, you could restructure your source data, and put the names in one
column, with multiple rows per day. Then you could create a pivot table
with week and name in the row area, day in the column area, and another
copy of Name in the data area, as Count of Name. Not exactly what you
want, but it would give a similar snapshot of the schedule.


David Nelson wrote:
Is it possible to have a pivot table return a non-arithmetic value? What I
have done is create a table of Date, Day, Week, Month, Year, Name 1, Name 2,
Name 3, Name 4. The pivot table has the days across the top (Monday,
Tuesday, ...), with rows being "weeknum"bers (26, 27, 28), and page controls
being month and year. So what I am after is filling in the name fields with
peoples names (Mary, Joe, Steve, ...), and having them display in the days
of the week that they have scheduled to work. Is this possible?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html