excel not enough memory to perform action

I would install and run one of these, save and re-open Excel with the file, see if the problem persists, then try the Safe Mode again if the problems are not solved by eliminating the excess formatting. This is supposed to be part of Excel 2013: Excel 2013 isn't listed but neither is Excel 2010 that I have and it works perfectly. You might also want to get this addin from Microsoft to eliminate excess formatting and to reset the last cell for the data. On the Manage menu, click Disabled Items, and then click Go.' 'To view the list of disabled items, display the Disabled Items dialog box by doing the following in the Microsoft Office program that you are using: I've followed threads lleadign to wild fixes that do nothing for my issue. I've changed Virtual memory unchecked boxes and checked others. Somewhere there is a setting to tell the program not to sort empty space. I have recreated the page and moved the info line by line and it moves as well. I have copied the page and the issue copies with it. I've added memory and the computer has more than enough room. When entering any simple formula or adding info, a column or a line, Excel take upwards of five minutes to make the change. All 1,047,000 lines and 17K columns or whatever it is. On the two other file tabs in this spreadsheet, excel tries to sort the entire workbook. Excel recognizes my 'info' entered as all there is to sort or filter.

So does the bottom slide tab that takes you from column A, sliding right with the bottom tab, to the last column I use. Scrolling with the slide tab on the right side takes you to the bottom line of info as you slide the tab down.

On the three normal pages, excel recognizes the information that I have entered as all that is needed to be sorted. I have five tabs on the spreadsheet and only two are affected. I have followed many suggestions on trying to fix this and I believe it must be something embedded in my simple spread sheet that is causing the problem.

Excel not enough memory to perform action