![]() ![]() Try opening the workbook on a different machine or in a later version of Excel.Restart your system, open Excel before anything else, and try to do the deletion.Save after the clearing and then try to delete the previously cleared columns and rows. Clear the contents of the columns and rows instead of deleting them.Delete rows and columns one row and column at a time, rather than deleting large numbers of rows and columns at once.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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |