Save after the clearing and then try to delete the previously cleared columns and rows.
Turn off automatic calculation before you attempt to do the deletions.(Microsoft isn't that great on providing helpful information in some of its error messages this particular message is a prime example.) There are a few things you can try that are quite easy. Tracking down and correcting this type of problem can be frustrating, as it could be caused by any number of things. He wonders if there are any thoughts as to how he can remove the columns and rows. Harvey has Googled the problem and tried all the suggested solutions but still has the problem. He needs to delete some rows and columns, but Excel gives an error message that he does not have enough resources. In total there are about 420,000 formulas in the worksheet. It has formulas in about 600 of those columns, some of which refer to other worksheets held on the server.
Harvey has a large Excel worksheet, cuurently 700 columns and 1000 rows.
