Create a new range of data in a new workbook and test the Pivot Table
function there. If it works, there's something wrong with your
original workbook. If it still doesn't work,
re-install Excel. Sometimes the least time-consuming problem-solving
is eliminating the possible causes.
--
DataCollector
------------------------------------------------------------------------
DataCollector's Profile:
http://www.hightechtalks.com/m368
View this thread:
http://www.hightechtalks.com/t2295289