"There are too many records to complete this operation". I got this Excel 2007 error when working with pivots.?

I never got this using 2003 and now I dont know how or why this error appears. Does anyone know how to work around or solve this? I am nowhere near the max amount of rows.