Forum Discussion
Excel formulas break (#REF error) when source workbooks aren't open
Hello Excel Experts, I'm facing an issue with an Excel file containing multiple formulas that reference three other Excel workbooks. All these workbooks are stored in the same folder on my OneDrive ...
Using the extension markup could be a fix. Also, using DB containers to allow access may help. Local host requires a connector to different end users. Pending on the schematic of the workbooks, the basic connection may not always be useful and functional. Think of cleaning up the formulas and communication channels utilized.