Recording macro to change source of a link crashes excel 365

Copper Contributor

Hi,
This happens locally and in Azure, on my machine, and 5 other peoples machines.
I can record anything else with out problem.
Change link macros I recorded in excel 2010 still work, and can be manually edited and run, I just can't record a new macro to do this.
This is what I might expect to record:
Sub Macro1()
'
ActiveWorkbook.ChangeLink Name:= _
"C:\Users\Robertc\Desktop\Book1.xlsb" _
, NewName:="Book2.xlsb", Type:=xlExcelLinks
End Sub
Any ideas?
Robert.

0 Replies