Forum Discussion
PLEASE Help with CELL("Filename")
I have noticed the same thing when using OneDrive. So long as both files (or all connected files) are open, it's the simpler reference. It does seem that both/all need to be opened in order for the destination sheet to have the most recent updated data from the source file(s)....but in my case that's not a problem.
I'm even using the new Dynamic Array functions to pull data from the other files, and they work just fine, "spilling" many rows and columns from the referenced file into the destination.
So I guess my question back to you is this: does it still work? Or is this a problem in that there are multiple users of one or more of the files in question?
I have a log file stored on onedrive I need to query with powerquery
log file (weather station generates) is stored on other computer and synced my working computers (several) through Onedrive.
I need to ensure that when I open or refresh my query - the find synced file. I couldn't quarantee that Onedrive root is same on all computers I use (i use same sometime during my trainings as demo and then I've to be depend of class setup)
Henn