Forum Discussion
Excel formula external link to workbook on OneDrive returns REF status
The formula is referencing the external file via this path: 'https://d.docs.live.net/1b1ecec231c6xxx/CapApp/Trail Life/[TL Sales by Item 10-01-2022 to 09-30-2023.xlsx]PT by Item by Month'!$A:$A. In ...
As a follow-up I tried the old Edit Links command in excel and it returned as a status "Warning! Values referring to other workbooks were not updated." When I then Open Source the cell formula works perfectly. If I close the file it again fails.