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?