Re: my huge 100K line file keeps freezing
Quote from snb;633384Did 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.