Dealing with large excel files - Helpful tip

[mnyjkspm]

I have been battling a large excel file all day and finally conquered.  I wanted to post so none of you have to waste time figuring it out. 
->->Never remove empty rows by selecting blank cells, Remove blank rows using the key column, Delete blank rows if your table does not have a key column
->->-> Fastest way to remove all empty rows:Quick Tools Add-in for Excel
Add Duplicate Remover add-in to your Excel and dedupe your worksheets quickly and easily :-)