Is it possible to share an Excel Workbook ?

[TheBionicOrange]

If I have an Excel Workbook with 20 sheets in (1 to 20), is there any way I can let multiple users use it at the same time ?

No more than 1 user would access the same sheet at the same time, but could person A use sheet1 whilst person B use sheet2 ?

I know you can set a workbook to be shared, but Excel seems to bombard you with prompts if more than 1 person accesses it, and I don't want the decision of which button the user decides to press to be the determining factor.

I just want to allow multiple users to use the same book, but only 1 user per sheet within the book.

[dglienna]

it wouldn't keep the integrity of the workbook if all sheets were changed constantly. I don't think there is any way around it. You'd have to figure out which changes to apply first, if you made 20 copies of the wb.

[RobDog888]

If you have SharePoint you can create a shared workspace for your Excel Workbook.