I use Excel 2010. Everything that I do involves a pivot table. I've been using them for years.
I've never had so many crashes as I have since using Excel 2010. I was modifying my raw data table today which is within the excel file as a table. I added 2 columns to the far right. I then went to my first pivot table in the workbook to change the range and my spreadsheet immediately crashed,,,,,white screen with the message Excel is trying to recover your file. This "recover" my file can take up to an hour and the end result is that my pivot table is no longer a pivot table.
I don't know where to look to figure out why my file has become so unstable that just changing the range makes it crash.
Any ideas of where to look? I don't use any macros or anything beyond having a table of data that I create a few different pivot tables for reports.
I've never had so many crashes as I have since using Excel 2010. I was modifying my raw data table today which is within the excel file as a table. I added 2 columns to the far right. I then went to my first pivot table in the workbook to change the range and my spreadsheet immediately crashed,,,,,white screen with the message Excel is trying to recover your file. This "recover" my file can take up to an hour and the end result is that my pivot table is no longer a pivot table.
I don't know where to look to figure out why my file has become so unstable that just changing the range makes it crash.
Any ideas of where to look? I don't use any macros or anything beyond having a table of data that I create a few different pivot tables for reports.
