Filtered data range reference is too complex
in [General]
|
Prev: 2007, excel column hdings are now numbered - how do I get letters
Next: Your entry cannot be used. An integer or decimal number may be
From: Kyle R Kyle on 17 Mar 2010 13:04 Twist on the same error message. I have a spreadsheet using approximately 630k cells. It has been the same relative size for several months. This week after I apply one or two filters I get this error when simply trying to use find/replace. "Shane Devenshire" wrote: > Hi, > > When you filter data there is a limit to the number of discontinuous > selections that Excel can handle. One solution is to sort the data so that > like items are grouped adjacent. Then apply the filter and copy. > Alternatively, you can select half of the filtered data and copy it, then > select the other half and do it again. > > -- > If this helps, please click the Yes button. > > Cheers, > Shane Devenshire > > > "Tony7659" wrote: > > > I am trying to copy/paste the filtered (subtotals) on my worksheet of about > > 17,000 rows. I do this every week. 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. Any help? Thanks. > > Tony. |