Recording macro to change source of a link crashes excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1526596%22%20slang%3D%22en-US%22%3ERecording%20macro%20to%20change%20source%20of%20a%20link%20crashes%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526596%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EThis%20happens%20locally%20and%20in%20Azure%2C%20on%20my%20machine%2C%20and%205%20other%20peoples%20machines.%3CBR%20%2F%3EI%20can%20record%20anything%20else%20with%20out%20problem.%3CBR%20%2F%3EChange%20link%20macros%20I%20recorded%20in%20excel%202010%20still%20work%2C%20and%20can%20be%20manually%20edited%20and%20run%2C%20I%20just%20can't%20record%20a%20new%20macro%20to%20do%20this.%3CBR%20%2F%3EThis%20is%20what%20I%20might%20expect%20to%20record%3A%3CBR%20%2F%3ESub%20Macro1()%3CBR%20%2F%3E'%3CBR%20%2F%3EActiveWorkbook.ChangeLink%20Name%3A%3D%20_%3CBR%20%2F%3E%22C%3A%5CUsers%5CRobertc%5CDesktop%5CBook1.xlsb%22%20_%3CBR%20%2F%3E%2C%20NewName%3A%3D%22Book2.xlsb%22%2C%20Type%3A%3DxlExcelLinks%3CBR%20%2F%3EEnd%20Sub%3CBR%20%2F%3EAny%20ideas%3F%3CBR%20%2F%3ERobert.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1526596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

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