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