Is it possible to share an Excel Workbook ?

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.

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.

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