Trying to create a pivot table, but I keep getting this error message...

"A field in your source data has more unique items than can be used in a PVT report. Excel may not be able to create the report, or may create the report without the data from this field."

My data has 48759 different ID numbers, is there a way around this error?
-Thanks