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.
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.
Does the above link help?
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.