• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Filter is super slow

katarinah

New Member
I have a large spreadsheet: 30,000KB, but until recently, it was functioning well.


Now, when I turn on the filter and try to change data by copying and pasting across the selection, it takes forever (30 minutes to change one cell across 1000 rows)


I tried removing the pivot table, removing functions, removing extra worksheets, and I brought the size down to 22,000KB, but it is still super slow, every time I try using the filter.


I would really appreciate any advice.

Thanks,

Katarina
 

Clarity

New Member
I'm guessing you've got a main data table and then formulae to the right enriching it?


Is there any of the functionality that can be done outside the spreadsheet? For example can you put the data and some of the calculations into another spreadsheet or even better in Access? This can then either be hard copied (ie without formulae) in or referenced by Pivot Tables.
 

Hui

Excel Ninja
Staff member
Katarinah

Have a read of this and try some of his suggestions

http://excel.tips.net/Pages/T002851_Reducing_File_Sizes_for_Workbooks_with_PivotTables.html
 
Top