B
Bagia
I am trying to copy/paste the filtered on my worksheet of about
140,000 rows. I do this every month. unfortunately, I am getting the
following
error now:
Microsoft Office Excel cannot create or use the data range reference because
it is too complex. Try one or more of the following:
- Use data that can be selected in one contiguous rectangle.
- Use data from the same sheet.
Both of the above apply to my selection. Is there a limitation? If so, what
is it?
Thanks in advance.
140,000 rows. I do this every month. unfortunately, I am getting the
following
error now:
Microsoft Office Excel cannot create or use the data range reference because
it is too complex. Try one or more of the following:
- Use data that can be selected in one contiguous rectangle.
- Use data from the same sheet.
Both of the above apply to my selection. Is there a limitation? If so, what
is it?
Thanks in advance.