Filtered data range reference is too complex
in [General]
|
Prev: Is there shortcut for merging cells when selected in Excel?
Next: Leave "formula cell J7" empty until H7 has a date.
From: Donberti on 20 May 2010 13:25 Hi Shane, nothing against stars - I think it is quite a contraddiction having so many line items in excel 2007 (compared to the 65k of excel 2003) and only 25k as limit. It takes me 45 min. to sort my data and I have tons. I will try to work on files using access. -- Donatella "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. |