Dec 16 2022 08:19 AM
Dec 16 2022 08:58 PM
Based on your text, it is not clear whether you are working in a network, Sharepoint, OneDrive, etc.
It is also not possible to see which Excel version you are working with.
If I may recommend, more detailed information would help those users who want to help.
Anyway, here's an old file that I got from the internet (unfortunately don't remember which site to send you the link from), used a few times...does your job.
This file is in VBA, I don't know if this is possible for you.
You can also try Share Workbook, here is a link with video instructions.
Hope to have helped anyway.
I know I don't know anything (Socrates)