I am getting an error message "Unable to get the Add Property of the Workbooks class" when running reports now. The last thing I had changed in Excel was page setting on the some tabs. I successfully created and link the sheet but now I can not run the report. It was running prior to these formatting changes.


The cursor was not on a tab nor do I have any other versions of Excel were open. (Excel 2010). I can unlink the template but I feel that I have to start over. Does anyone haver any suggesstions.

Views: 1158


Reply to This

Replies to This Discussion

Hi Michael -- did you ever find a resolution to this?  I have a report I created and tested on a backup of my customer's data and it ran fine and then after installing on their system they are getting this error.

Helped me!

So I spoke too soon yesterday. It seems that the fix fixes the issue and the report runs the first time. If you run it the second time, it gives you same error.

I am having this same error. the fix file did not work.  How did you solve your issue?

Still no resolution found.

Having a similar problem when running a report on a client workstation (that runs fine on my office workstation):

Hangs at the “Creating Excel Workbook” stage:

  • Each time is gives the Visual Basic Application error - “Errors occurred during load”
  • Followed by the "Unable to get Add Property of the Workbook Class" error

Tried installing the brand new exported report right after successfully running it on my machine with their data – same errors

Tried running the report from the sample company (Bellwether) data file – same errors

Tried running the “fix templates” program – same errors

Tried removing ALL the macros – same errors

My Windows version - Win 10 Home build 15063.674

Clients Windows version – Win 10 Pro build 16299.125

My Excel build version - 2016 MSO (16.0.7127.1026) 32-bit

Clients Excel build version – 2016 MSO (16.0.8730.2046) 32-bit


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service