Hi Donna

What is the error message?
What is the range that you are giving to the Pivot Table?

--
Regards

Roger Govier


"Donna W" <Donna wrote in message
...
Main sheet is 10 columns and 3696 rows. when creating pivot table get
error
message. What can i do to get full spread sheet to load? the rows
contain
names,
names go up to starting with Z but only load rows that go up to S.