If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Problem with OLE automation and excel.chart.8

Thread starter Overkill32
Start date Sep 20, 2011

Overkill32

New Member

Sep 20, 2011

I have a problem using a graph that was probably created using an excel.chart.8 automation (when i select the chart, the formula is as follow : =INCORPORATE("Excel.Chart.8".""). We have a file where we need to update the data that is linked to it. Normaly, we would double-click the chart to open the window where the graph is and where the data is in another tab. Unfortunately, when i try the same process, Excel tells me that there was an error accessing the file and that the connexion to the network might have been lost. Also, it says it can't start the source application of the object.

Can anyone please help me on this issue!