• 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

K

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
 
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.
 
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
 
You must log in or register to reply here.
Back
Top