I have a worksheet we’ve been using for years in Excel with
lots of Datalinks to an AutoCAD dwg.
About 6 months ago IT moved us all to Excel 2016 and ever since
the Datalink update process has been abysmal.
Upwards of 80% of the time, AutoCAD crashes trying to do the
update (with the previous version of Excel, it was 0%).
If you click and update each table manually, it generally does
work, but the update all option has a very low success rate.
I’m pretty good with VBA, so I was thinking of maybe
programmatically looping through the datalinks with a little
pause in-between each update to hopefully allow the 190+ links
to update without crashing AutoCAD.
I’ve started fumbling around with
ThisDrawing.Database.Dictionaries and “ACAD_DATALINK” but got
stuck trying to look inside the dictionary..
Any help would be great.