Prev: IF - more than seven arguments
Next: Removing ''VALUES''
From: LiAD on 25 Mar 2010 09:05
Afternoon,

I have an excel sheet of 10 cols and 200 rows on sheet 1.
Sheet 2 has a table which searches through the list of data in sheet 1 to

1 - produce a list of unique items using the formula -
2 - find max/av/min of col F per item using formula -
3 - find max/av/min of col G per item using formula -
4 - count how many results per item there are using -

Indirect is used to drive the address so as the file only searches through
rows which contain data.

When i try and use the filters on sheet 1 to search specific items etc the
file is very long to update.

Is there a reason why it is so long to activate when i try to filter?
How can i speed this up?

Thanks
Lindsey

From: Ashish Mathur on 25 Mar 2010 22:06
Hi,

One reason could be that the file is linked to other Excel files. If that
is indeed the case, then paste special values the external links and see if
filtering happens fine

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"LiAD" <LiAD(a)discussions.microsoft.com> wrote in message
news:3AEB2A66-B1E0-4E48-856E-EDC9FC4ADB03(a)microsoft.com...
> Afternoon,
>
> I have an excel sheet of 10 cols and 200 rows on sheet 1.
> Sheet 2 has a table which searches through the list of data in sheet 1 to
>
> 1 - produce a list of unique items using the formula -
> 2 - find max/av/min of col F per item using formula -
> 3 - find max/av/min of col G per item using formula -
> 4 - count how many results per item there are using -
>
> Indirect is used to drive the address so as the file only searches through
> rows which contain data.
>
> When i try and use the filters on sheet 1 to search specific items etc the
> file is very long to update.
>
> Is there a reason why it is so long to activate when i try to filter?
> How can i speed this up?
>
> Thanks
> Lindsey
>
 | 
Pages: 1
Prev: IF - more than seven arguments
Next: Removing ''VALUES''