Resolving Excel Crashing when calculated field is added to PivotTable
Andrew Watson
May 05, 2008
PivotTable is a tool used in MS Excel to summarize the data and to represent in a suitable manner by creating another table with the summarized results. Other functions of it include sorting out, counting or totaling the data stored in a table or spreadsheet. PivotTables are frequently used to extract statistical information from raw data.
Calculated fields are additional fields to your pivot table which are actually existing fields containing functions. They are the user-defined fields in a PivotTable that can perform calculations using the contents of other fields in the PivotTable.
But sometimes, when you try to add a calculated field to the pivot table in your Excel sheets, you may encounter the following error message:
"This program has performed an illegal operation and will be shut down."
When further you click on its details part another error message gets displayed:
"EXCEL caused an invalid page fault in module EXCEL.EXE at 015f:300fbe4a."
These are error messages are generated in Windows 95 and98. But in Windows 2000 the same condition may generate the following error message:
"Excel has generated errors and will be closed by Windows. You will need to restart the program."
After these error messages the Excel quits unexpectedly.
The reason for the above error messages could be any like if you try to insert calculated field into a PivotTable report or the source of the PivotTable report contains 5,117 records or the data in the PivotTable is corrupt and need an Excel Repair.
The data present in the PivotTables may be of much worth to the users. In case of accounts related information, the corruption in this data can be a big loss as these are the frequently used tools there. So Excel repair is on high demand in these cases. But choosing the best tool and the most reliable one is mandatory to avoid further data loss.
Stellar provides the most trustworthy and advanced tool for this in the name of Stellar Phoenix Excel Recovery software. This Excel Repair software utilizes the most powerful algorithms to extract the data as much as possible by carrying out a complete scan of the corrupted Excel spreadsheets.
The data in the PivotTables can easily be repaired along with the formulas which had been actually applied. The data remains in its actual format and view with the use of this Excel repair software. This Excel repair software works well with all the file versions of MS Excel like Excel 2000, 2002/XP, 2003 and 2007.
The user interface is quite trouble-free to use and demands no prior technical knowledge from the user. Its demo version (available on the website) is a way to help you evaluate its skills as it will sample you all the repairable files and thus acting as a complete solution for all your Excel repair problems.
Calculated fields are additional fields to your pivot table which are actually existing fields containing functions. They are the user-defined fields in a PivotTable that can perform calculations using the contents of other fields in the PivotTable.
But sometimes, when you try to add a calculated field to the pivot table in your Excel sheets, you may encounter the following error message:
"This program has performed an illegal operation and will be shut down."
When further you click on its details part another error message gets displayed:
"EXCEL caused an invalid page fault in module EXCEL.EXE at 015f:300fbe4a."
These are error messages are generated in Windows 95 and98. But in Windows 2000 the same condition may generate the following error message:
"Excel has generated errors and will be closed by Windows. You will need to restart the program."
After these error messages the Excel quits unexpectedly.
The reason for the above error messages could be any like if you try to insert calculated field into a PivotTable report or the source of the PivotTable report contains 5,117 records or the data in the PivotTable is corrupt and need an Excel Repair.
The data present in the PivotTables may be of much worth to the users. In case of accounts related information, the corruption in this data can be a big loss as these are the frequently used tools there. So Excel repair is on high demand in these cases. But choosing the best tool and the most reliable one is mandatory to avoid further data loss.
Stellar provides the most trustworthy and advanced tool for this in the name of Stellar Phoenix Excel Recovery software. This Excel Repair software utilizes the most powerful algorithms to extract the data as much as possible by carrying out a complete scan of the corrupted Excel spreadsheets.
The data in the PivotTables can easily be repaired along with the formulas which had been actually applied. The data remains in its actual format and view with the use of this Excel repair software. This Excel repair software works well with all the file versions of MS Excel like Excel 2000, 2002/XP, 2003 and 2007.
The user interface is quite trouble-free to use and demands no prior technical knowledge from the user. Its demo version (available on the website) is a way to help you evaluate its skills as it will sample you all the repairable files and thus acting as a complete solution for all your Excel repair problems.
Print
Share
Email
