E
embedded excel breaklink error
I have a presentation with many embedded excel objects. Some cells in the
embedded objects are linked to an external spreadsheet. I have a macro that
loops through all shapes and calls updatelink. Something like this:
Shapes(J).OLEFormat.Object.Application.Workbooks(1).UpdateLink Name:=
"data.xls", Type :=1
I also need changelink and breaklink. Updatelink and changelink both work,
but breaklink gets me an "automation error: the server threw an exception"
What am I doing wrong?
embedded objects are linked to an external spreadsheet. I have a macro that
loops through all shapes and calls updatelink. Something like this:
Shapes(J).OLEFormat.Object.Application.Workbooks(1).UpdateLink Name:=
"data.xls", Type :=1
I also need changelink and breaklink. Updatelink and changelink both work,
but breaklink gets me an "automation error: the server threw an exception"
What am I doing wrong?