none
Excel share workbook in a shared folder RRS feed

  • Question

  • Hi,

    I just need your kind help for me to begin the right thing.

    I have a workbook with 10 spreadsheets which is save in a Share Folder

    This what I need to do

    1. I need to share this to workbook for other users around 10, It's possible in excel?

    2. I need this 20 user can entry/edit data  only from the cell L1:P20000 only at the same time at anytime?

    3. this 10 users can not do entry, edit, change data from the cell A1:K20000 for it's exclusive for me, can I do that?

    4. I want also to restrict users from inserting rows or cells, users are only exclusive data entry or edit entry to a certain record?

    5. Except me as one of user can freely do all functions inserting and deleting, entry or edit?

    Can you please give me some thoughts to make it happen, please.

    do I need a VBA code to do this thanks in advance for any help.

    thanks

    M032313

    Sunday, October 26, 2014 4:51 AM

Answers

  • I don't think you have to go to VBA yet. Assuming you are using Excel 2010 you can take a look at Sharing Workbooks. Go to the Ribbon, Review tab.

    Under the reviwe tab look in the group Changes look for the Share Button. Take a look at the options availble there. Furthermore take a look at the button 'Allow users to edit ranges' which might be exactly what your are looking for. So combine the various options and you might just have the answer you are looking for.


    Maurice

    Sunday, October 26, 2014 7:42 PM

All replies

  • I don't think you have to go to VBA yet. Assuming you are using Excel 2010 you can take a look at Sharing Workbooks. Go to the Ribbon, Review tab.

    Under the reviwe tab look in the group Changes look for the Share Button. Take a look at the options availble there. Furthermore take a look at the button 'Allow users to edit ranges' which might be exactly what your are looking for. So combine the various options and you might just have the answer you are looking for.


    Maurice

    Sunday, October 26, 2014 7:42 PM
  • Thanks so much, appreciated.
    Tuesday, October 28, 2014 6:18 PM