Edit a shared file simultaneously
DJ2020
Posted messages
12
Status
Membre
-
DJ2020 Posted messages 12 Status Membre -
DJ2020 Posted messages 12 Status Membre -
Hello,
I have a shared Excel VBA file on the network....I would like to know if there is a trick so that all users can edit the file at the same time, knowing that each user has their own sheet in the file to modify.
Actually, I tested it, but an alert appears that the file is read-only because another user is currently editing it.
Thank you
Configuration: Windows / Chrome 79.0.3945.117
I have a shared Excel VBA file on the network....I would like to know if there is a trick so that all users can edit the file at the same time, knowing that each user has their own sheet in the file to modify.
Actually, I tested it, but an alert appears that the file is read-only because another user is currently editing it.
Thank you
Configuration: Windows / Chrome 79.0.3945.117
4 réponses
Hello,
I will be less categorical than the other speakers.
A shared file can be used and modified by several users simultaneously.
The only thing is that you have to manage collisions if multiple modifications affect the same cell. There you need disciplined people who accept to abandon their modifications to redo them when they receive the alert.
We can reduce the risk of collision by saving the file before modification, which forces it to pull an update.
If each person has their own sheet as announced, this risk is null.
The fact that some users are read-only is not normal.
It should not be Shared in the Excel sense: Review tab, Share Workbook.
Some features prohibit sharing (tables for example).
Others are limited and require unsharing while making the modification.
VBA is not prohibited and works for the vast majority of actions. What is blocked is its modification as long as it is shared.
To see what is the case for 365, perhaps more limitations or even more sharing possible?
On 2019 I had to add it to the ribbon. Probably a feature in the process of being phased out. To push people towards OneDrive?
Please specify your version.
Eric
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to thank you (yes yes, it happens!!!), remember to mark it as resolved. Thank you.
I will be less categorical than the other speakers.
A shared file can be used and modified by several users simultaneously.
The only thing is that you have to manage collisions if multiple modifications affect the same cell. There you need disciplined people who accept to abandon their modifications to redo them when they receive the alert.
We can reduce the risk of collision by saving the file before modification, which forces it to pull an update.
If each person has their own sheet as announced, this risk is null.
The fact that some users are read-only is not normal.
It should not be Shared in the Excel sense: Review tab, Share Workbook.
Some features prohibit sharing (tables for example).
Others are limited and require unsharing while making the modification.
VBA is not prohibited and works for the vast majority of actions. What is blocked is its modification as long as it is shared.
To see what is the case for 365, perhaps more limitations or even more sharing possible?
On 2019 I had to add it to the ribbon. Probably a feature in the process of being phased out. To push people towards OneDrive?
Please specify your version.
Eric
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to thank you (yes yes, it happens!!!), remember to mark it as resolved. Thank you.
yg_be
Posted messages
23437
Registration date
Status
Contributeur
Last intervention
Ambassadeur
1 587
no, Excel is not suitable for doing that in a single file.
Hi,
yes, we cannot modify a shared file at the same time as multiple people and fortunately, otherwise we would generate as many false versions of the file.
In fact,
databases were invented to achieve this, the locking is limited to the record level, not the database level, it's much more flexible.
--
and ... There you go!
yes, we cannot modify a shared file at the same time as multiple people and fortunately, otherwise we would generate as many false versions of the file.
In fact,
databases were invented to achieve this, the locking is limited to the record level, not the database level, it's much more flexible.
--
and ... There you go!
I agree with eriiic. The ability to work collaboratively on the same file has existed for a long time. It's called co-authoring.
Now, it depends on the version used.
With 365, you just need to grant permission to other people, and you can easily track the changes made by others.
See here:
https://support.microsoft.com/fr-fr/office/collaborer-sur-des-classeurs-excel-simultan%c3%a9ment-avec-la-co-%c3%a9dition-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=fr-fr&rs=fr-fr&ad=fr
m@rina
apparently co-editing is for sharing on the cloud.
On the network, to share 'the old-fashioned way', see if on 365 we can add the tool to the ribbon like in 2019 (right-click on it and Customize)
eric
If yes, you need to check 'Use old feature' to be able to do it on a local network. Then you can go to the 'Advanced' tab to enable auto-save and choose the delay.
If not, look under 'Multi-editing' (I don't have it and don't know its content) to see if you can find the equivalent.
eric
as for the tip "enable auto-save," what exactly does it help me with in my problem... I am asking for your help to explain it to me properly, thank you Eriic