Hardcore users only - help needed to clean up a Workbook

ecovonrein 

You've encountered the limitations of Excel's old design, particularly when handling cross-workbook links and environments like SPO and OD.

Your observations highlight some deep-seated issues within Excel’s codebase, especially with the divergence between how grid-based references and named references are handled, along with the complexities of auto-updating links across different environments.

From what I understand, you have encountered a really frustrating point with Excel's handling of external references, especially when integrating SharePoint Online (SPO) and OneDrive (OD).

Perhaps by adjusting the timing of your VBA procedures (using Workbook_Open and Workbook_BeforeClose) and implementing centralized link fixing logic, you should (in theory) be able to minimize the noise caused by Excel trying to resolve links before executing your code. This is all theoretical, because it's a bit beyond my knowledge, to be honest. Maybe you could add AI to your topic about this.🙂