Multiple users updating excel spreadsheet
We would like for the file to open for the first person.And then for any others after that, get a message that the file is in use WITHOUT the option to open a read-only copy. I've put an Excel spreadsheet onto my One Drive and have shared it out to some of my family members granting them edit privileges, who are all people I've added to my Office 365 account.What I'm wondering is if two or more people that I've shared the spreadsheet, be able to have the spreadsheet open and editing it at the same time? I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename).I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. Thanks, Jason I would like to send an Excel file with hyperlinks of photo's attached to cells but when it is sent the recieving person cannot access the hyperlinks anymore. The file contains archive info that we do not have anywhere else.It's a master database for a project that we all are working on. So, now I want to restrict access when some one is in the file.Currently, if someone is in a file that you want to access, it gives you three options: -Open Read only -Notify -Cancel I want to disable this. I have an excel 2007 file sitting in a shared network folder.
For some reason it currently does not do this, and I have multiple users with the same doc open.
MS Access is not an option for me so I was wondering if you could help me do this in excel.
thank you so much and would really appreciate to hear from anyone soon.
In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one.
Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder.
Search for multiple users updating excel spreadsheet:
and input the macro I'd need to run in each file in the appropriate location. I am using 2007, I have tried to send the folder but that didn't seem to work. I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Is there anyway then to open the file or to reduce its size without opening it (through magics...)?