Hi all,
I have a few Microsoft forms which deposit their data in my work Onedrive. I can make a data connection from these forms to another excel doc that I use as a dashboard so that when a new submission comes in that doc automatically updates.
The issue I have is this only happens if I have a copy of the excel doc dashboard open in the excel app as opposed to open in one drive. If I close the app the One drive version does not update.
I need to share the one drive version with other people and its not feasible to leave the app permanently open on my laptop.
Am I missing something?
I have a few Microsoft forms which deposit their data in my work Onedrive. I can make a data connection from these forms to another excel doc that I use as a dashboard so that when a new submission comes in that doc automatically updates.
The issue I have is this only happens if I have a copy of the excel doc dashboard open in the excel app as opposed to open in one drive. If I close the app the One drive version does not update.
I need to share the one drive version with other people and its not feasible to leave the app permanently open on my laptop.
Am I missing something?
