I was just having the same problem after reinstalling everything on a new computer.  What finally worked for me is under the Options/Settings, check the box that says "Force Alternate Connection Method Provided for Excel 64-bit"