This just started this morning. I run power queries on my files, so I need an absolute local path. For ease, I have a cell with =CELL("filename",A1) to provide said local path, from which I can run the relevant queries. Today, they all broke. The filepath is showing the online path (https://xxxx-my.sharepout.com/personal/...) rather than the local file path. I thought it might be an issue with where the file is stored, so I went to the OneDrive folder on my computer and set everything to "Always store on this device" then let everything download, but it's still pulling through the online path, rather than the local. How can I get it back to local path so the Queries can work?
1
votes
Try opening OneDrive folder from the start menu and then reopen the workbook.
– Naresh
Following the file path and then opening the workbook doesn't help. Is there a setting or something I may have clicked that asks it to always use the online version? Even creating a new workbook in the folder (from Windows Explorer) and checking the filepath of that new file shows the online path.
– Spencer
1 Answers
0
votes
Reading discussions of similar problems on some Microsoft support site suggests that this is by design. One workaround that I've seen discussed is to go into your OneDrive settings and disable "Use Office applications to sync Office files that I open". I think this will work BUT there is a downside (TANSTAAFL).
As I understand it, with this disabled, you are no longer guaranteed that the document is being updated if someone else modifies that file and there may be problems merging changes made in multiple places. I've not seen any good discussion of the negatives although the "More info" link in the settings might be helpful to others (they don't help me much).
