So............... when hitting "refresh all" in a spreadsheet full of data blocks you worked for two days on, make sure you don't have another spreadsheet open that has corrupted data blocks in them, because this will in turn corrupt your brand new ones by trying to pull an alien like maneuver in trying to forcibly attach themselves to your new set of data blocks. When you then go to save said document, it will crash MS Excel over and over and over again.... Thereby forcing you to go through and remove all the bad data connections in order to get the document to save. If you do not follow this advice it will put a serious damper on your morning.
omniture