While trying to import a budget from Excel in GP 10 we got this error -
Unhandled Object Exception
Unable to access field ‘Workbooks’
Exception Class Object Exception
Followed by the message –
You must have excel installed on this machine in order to run this application.
Excel was definitely installed. The excel sheet was closed. I looked around in newsgroups and knowledgebase but did not find anything useful. Our in house GP expert Rubal told me to look into the task manager to check if there was an instance of Excel in there. Sure it was. I ended that instance and the error went away.
Surprisingly I have seen this error twice in two weeks with two different customers, so I thought of putting it out here in case one of you found it useful.
The original Error
Followed by the message - You must have excel installed on this machine in order to run this application.
End the Extra Excel Process in Task Manager