Another update FWIW. Another user who has exactly the same version of Excel and has no issues using the Excel Direct on their workstation I just tried logging in as that user on the workstation in question and it still crapped out.

So initial thought it doesn't appear to be a user issue.