How to access the same workbook by multiple users simultaneously in the same network?

Hi All,

Is it possible to access the same workbook and made changes(Like passing the cell values from other workbook) for multiple users of the same network simultaneously.

Here is the problem.

I have 2 workbooks say "first.xlsm" and "second.xlsx".

from the "first.xlsm", i am passing the cell values to "second.xlsx" file.
Now if i put the "second.xlsx" in the shared folder and distribute the "first.xlsm" file to all other users of the same network.
But the problem is they are not able to pass the values to the "second.xlsx" file and at that time an error message is showing.

Here you can find the error message snap shot.
shareProblem.JPG

Please help me to achieve the thing what i have explain above.

Regards
Kumar

Hi Bony,

Please see the attached image.
SeeImage.PNG

from this file based on the selection after clicking the button,the value is stored in the second.xlsx file.
Like wise if i choose the same option multiple time the cell value will be updated.(Like 1,2,3,4,5,6 etc)

Ex:
second.xlsx
A1(opt1) B1(opt2) C1(opt3) D1(Opt4) E1(Opt5) F1(opt6)
1 2 1 3 2 1 ----->This count will increase based on the no.of times
you select the same option.

If other users also how to update these values if they select their options.

Regards
Kumar