I resolved this issue it had to deal with the version of QuickBooks being either 64 or 32 bit. Or Microsoft Office being 64 or 32 bit.  I can't remember at this point but that was the exact reason Excel was not functioning with QuickBooks