my huge 100K line file keeps freezing

    I'm working on a huuuge excel file that keeps freezing and is therefore taking me ages to finish working with. I'm hoping someone can advise how to lower the processing time. This file has 100K rows. It even freezes when I'm scrolling! The main actions I'm taking within it, if this is relevant, is that I'm applying a couple filters at a time then putting in information into the first line and pasting that all the way down.


    I was working on another file of the same length last week. That was also very slow in the beginning until I shut off automatic calculations, made them manual. But that hasnt fixed things here.


    Can anyone help?


    Thanks
    Dan

    Re: my huge 100K line file keeps freezing


    What are you using the file for? At that size, and if you're mostly filtering to create sub-sets, a database program is going to be faster, more reliable, and less likely to go wrong in unexpected and/or catestrophic ways.

    Re: my huge 100K line file keeps freezing


    Did you check the amount of tablequeries in the file ?
    Did you check the amount of drawingobjects in the file ?
    Did you check the amount of links in the file (and whether they are valid) ?
    Does the file contain any workbook eventcode or worksheets eventcode ?
    Does the file contain dynamic named ranges ?

    Re: my huge 100K line file keeps freezing


    Quote from LocalPeople;633376

    What are you using the file for? At that size, and if you're mostly filtering to create sub-sets, a database program is going to be faster, more reliable, and less likely to go wrong in unexpected and/or catestrophic ways.


    a work assignment. basically checking who the singer of each song in thsi excel file is in a paper list i have, and then putting it into excel.

    Re: my huge 100K line file keeps freezing


    Quote from snb;633384

    Did you check the amount of tablequeries in the file ?
    Did you check the amount of drawingobjects in the file ?
    Did you check the amount of links in the file (and whether they are valid) ?
    Does the file contain any workbook eventcode or worksheets eventcode ?
    Does the file contain dynamic named ranges ?



    i dont know what all that means or how to do that, but it doesnt look relevant. not using any vlookups or external code.

    Re: my huge 100K line file keeps freezing


    You have no idea how you can litter a file by copying/pasting from websites.....
    The file doesn't freeze on it's own accord. So you have to play detective... assumed non relevance doesn't speed up any workbook.

    Re: my huge 100K line file keeps freezing


    Quote from bigdan;633456

    basically checking who the singer of each song in thsi excel file is in a paper list i have, and then putting it into excel.


    Data entry is something else that a database would handle better; if nothing else, converting to a database (or even a .csv) would strip out everything that snb mentioned, if there is anything like that in there.
    Just to make sure we're clear, does this file contain anything but text and numbers? How many columns are you using?

    Re: my huge 100K line file keeps freezing


    I suggest that if you have over 100k rows, excel probably isn't the best tool to work with. Do you have access?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login