How can I speed up editing a BOM of a top level assy?

I have a major assembly with the following details:

1,642 total components
1,406 parts
280 unique parts
236 sub assemblies

When I create a BOM for this major assy, its very slow to edit theBOM. I know I can export it to Excel, but then it wouldnt be linkedanymore.

Any suggestions?

SolidworksBill Of Materials