I have created a central Excel Workbook on my OneDrive that contains data that operators will use other Excel Workbooks to read and write too simultaneously.
I'd like to have the central Workbook hidden to simplify the operator's perspective.
Everything seems to be working as intended when the central Workbook is visible, but when I hide the central Workbook each operator appears to have his own cached version of the central Workbook. This mean that if operator one changes a cell value using the macros I have written operator two cannot read that changed value with his.
I have tried unhiding the central Workbook when the macros begin and even using the calculate command, but these methods do not update the workbook to match itself on other operator's computers.
