We have a file with a sheet with a fairly small amount of data. Approximately 13 columns and 10,000 rows. We applied a filter to one of the columns bringing it down to 1823 rows. Clicking on the top left square to select the entire page, and then copying it, and creating a new sheet and pasting it in causes excel to throw an error about being out of memory.

We have worked around this by selecting the top left cell and clicking control + shift + end, and then copying the data that way. The issue is some people are extremely slow to learn and I am fielding questions about this often.

If we disable the filter we can copy the entire sheet just fine as well by clicking on the top left square.



Does anyone know why filtering the dataset is causing it to run out of memory when copying to a new sheet? and/or if their are any patches/settings that fix this?

I do know that excel treats "hidden" rows as a lot of data for some reason. Have you tried making a copy of the worksheet itself. If some people are having a hard time with that a macro is always really good because you can write the macro have it assigned to an autoshape and then just have the user click on that auto shape. Thats what I had my work do when they needed to print just a range on a worksheet instead of the entire worksheet.

You have to study this: http://www.decisionmodels.com/memlimitsc.htm