Jun 30 2022 07:53 AM
I'm getting a rather annoying and regularly occurring issue where I am reopening a workbook that I have worked hard on with a lot of functions based on data in an external workbook and seeing a #value. regardless of whether I ask excel to update or not update when I get the prompt to update the external links, these values do not change. Now these two workbooks are both stored in the same folder on OneDrive so I don't understand why this issue keeps happening. Why is it simply not just running the function on the most up to date value in the other workbook given they are stored in the same folder?
Jul 01 2022 02:04 AM