Tuesday, January 6, 2009

Unhandled Object Exception While Importing a Budget from Excel

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

clip_image002

Followed by the message - You must have excel installed on this machine in order to run this application.

clip_image004

End the Extra Excel Process in Task Manager

clip_image006

1 comments:

Anonymous said...

Thank you for this. It was driving me crazy trying to create a new budget.