OLE Error with Pivot Table view on form

We are getting the following error when we try to open a form with a pivot table view via a macro:
The connection with the OLE server was lost, or the OLE server encountered an error while you were using it

Some computers get the error and some don't.    Any ideas what would be causing this error?
msanzenbAsked:
Who is Participating?
 
stevbeCommented:
Make sure the Office Web Components are installed on all machines.

Steve
0
 
msanzenbAuthor Commented:
How can I confirm if Office Web Components are installed on a machine?
0
 
stevbeCommented:
Not sure how to check it directly but you can go to Control Panel, INstall/ Remove Programs select Office and then chekc the Office Web Components in the Office Shared Feature section.

Steve
0
 
msanzenbAuthor Commented:
That worked...thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.