I've had this error a few times but never figured out why. With the help of a few posts around the web I finally found out the reason. If you have opened a none excel file like a csv file, then you get this error "Data source reference is not valid" really helpful. The solution is to save...