stanl
07-07-2018, 06:11 AM
I may be basically behind the times on this, but I have used a generic function to either open or create a new Excel workbook which more or less set application properties, i.e. visible, screenupdating, user control, displayalert, and updatelinks. But now using Excel 2016 rather than 2010 it appears updatelinks is now a workbook property and the application object now has AskToUpdateLinks which is applied to Excel 2013 and greater.
I modified my function to check or application.version <15 but I think I will miss turning updating off at the application level, especially with extended updating for power query and power pivot.
Since I want to avoid the pop-up for link updating setting AskToUpdateLinks to false does that, but it also means any links are auto-updated.
Be nice if there was a .hasLinks property, or is this just a mountain/molehill I have created.
I modified my function to check or application.version <15 but I think I will miss turning updating off at the application level, especially with extended updating for power query and power pivot.
Since I want to avoid the pop-up for link updating setting AskToUpdateLinks to false does that, but it also means any links are auto-updated.
Be nice if there was a .hasLinks property, or is this just a mountain/molehill I have created.