Stop automatically linking when copying data!
Excel frequently freezes when looking for phantom links that are inserted when I copy over data from a sharepoint saved file to my local machine. Please make the default a clean data copy with no tie to the original source, as excel freezes when searching through linked files linked to other files linked to other files that don't exist...it's like sharepoint cancer for excel :(
So so much! I've got links in my files to organisations I've never even heard of!