I have some pivots set up in a worksheet that are pulling data from a sheet in the same workbook. (Not an external source). When I get new data, I usually change data source and refresh the pivots. It has worked in the past.

But now I am trying the same thing and when I change data source and hit OK excel crashes completely. I tried saving the data into another sheet, tried to convert .xlsx to .xls but it still crashes.

Any help to fix this is appreciated!