MartyCollins
New Member
- Joined
- Jan 21, 2022
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
Hi there,
I have a workbook that references another workbook whose values change quite often.
Both are online on our work sharepoint -- however i have noticed that Xlookup does not work with them. (well it does when i open the source workbook in the desktop app, but then stops working when I try refresh it online)
Basically this forces me to have to open the source file in the desktop App to refresh values in the "report" file-- which is a PITA.
I have done some research and dont seem to be the first to have come across this issue but some of the posts i read were from 2017-2021 so maybe there is something new that im missing.
Appreciate any help.. maybe the 2 workbooks need to be in the same folder in sharepoint or something? (vlookups work across the 2 files but they are meh!)
Thanks,
Marty.
I have a workbook that references another workbook whose values change quite often.
Both are online on our work sharepoint -- however i have noticed that Xlookup does not work with them. (well it does when i open the source workbook in the desktop app, but then stops working when I try refresh it online)
Basically this forces me to have to open the source file in the desktop App to refresh values in the "report" file-- which is a PITA.
I have done some research and dont seem to be the first to have come across this issue but some of the posts i read were from 2017-2021 so maybe there is something new that im missing.
Appreciate any help.. maybe the 2 workbooks need to be in the same folder in sharepoint or something? (vlookups work across the 2 files but they are meh!)
Thanks,
Marty.