you must have a list structure to create pivot table.
that's mean:
title row, and empty row on the bottom and and top of the list, an
empty column on each side of the list.
:rolleyes

--
Message posted from http://www.ExcelForum.com