Yeah - you'd think. I'm familiar with that process.
But it's not there. My workbook is not showing up as an option. This 'change source' process is anemic, frankly. Maybe it's a SharePoint thing or a OneDrive thing. But whatever it is, it's not there. Changing the source to your own workbook isn't an option, and it shouldn't be as wanderingly confusing as it is anyway. 'Point to yourself' - there, done. At the moment Excel forces you to hunt for the workbook you're actually working in like a dog chasing its own tail.
I can even save my workbook, close down Excel (I'm using the desktop version, not the lesser web-based version), restart it (the desktop version), and my workbook isnt on the list of recently saved workbooks, nor can I navigate to it in the file explorer (cause it's not really in File Explorer's realm - it's on SharePoint).
There's got to be a better way.
Seriously, there's got to be a better way.
I want to change this kind of formula that point to the PATIENTS sheet in another workbook:
to this cause the PATIENTS sheet is now in the same workbook as the formula:
Thanks.
Bookmarks