It takes me well over 60 seconds to load a file that is 4,000KB. I have
tried everything I've seen in other posts to get this file to load faster but
none have worked.

I've repaired Excel, unchecked use DDE and put the %1 in, opened Excel and
selected the file through those methods. However, I still have to wait
anywhere from 45 seconds up to 4 hours was the longest loading time to date.

I have 14 Excel files that I work with on a daily basis and this is the only
one that gives me any trouble. There are many calculations and links to
various other sheets, but that is contained in all 14 sheets.

Can you figure out why this one sheet takes so long to load and how do I
prevent this?