Forum Discussion
Sharing Excel file
- Jan 09, 2022
Hi SimPet87
yes, you summarized it correctly.
It seems, that the OneDrive app is currently not running on your computer. So first thing would be, to start the OneDrive app. As it seems that you can see already a OneDrive folder in the Windows explorer, you could do a right-click on the folder and adjust the settings, so OneDrive gets started automatically and the syncronization is activated.
After that, I cross fingers, you should be fine 😉
Hi SimPet87
if you store the file on local folder (outside of OneDrive) and click on the Share-button, only a copy of the file gets loaded to the cloud. And this leads to the issues that you are having now.
Instead, you need to store the file first on OneDrive (which could be also on a local folder that gets synced to the cloud) and only then share it. This way, everybody (including yourself) is working with the same file, and not just on a copy.
The other option you suggested was to store the file in a local folder and then connect it to the cloud, could you tell me how I can do it?
Thanks again really
S.
- Martin_WeissJan 07, 2022Bronze Contributor
Hi SimPet87
sorry for my late reply. I guess that you are using OneDrive, otherwise it would not possible to share a file. So my assumption was, that you have something like this on your computer:
If my assumption is right, then you should store your Excel file somewhere within this OneDrive-folder and share it from that location.
And then you should also work with the file from this OneDrive folder that you have choosen. This way, it is the same file that the other user works with.
If you, for example, copy the file from a folder on the C: drive to OneDrive folder, but then continue to work with the file on the C: drive, the other user always just gets a copy of the original file. And you face the problems that you described.
I hope, it's a bit clearer now. Otherwise, just let me know.
Kind regards,
Martin
- SimPet87Jan 08, 2022Copper ContributorHello, thank you very much for your availability; in fact I have the onedrive folder on my pc so have a good starting point :); I did not understand one thing, however, I created my file on my pc (C folder) and then moved it to the OneDrive folder; how can I now share it so that everyone modifies it at the same time? do i have to click on "share"? Could you show me the whole process? Thanks and sorry
- SimPet87Jan 08, 2022Copper ContributorI tried to modify the file that is in my onedrive folder and then check the change on onedrive web but it is not registered