Excel dynamic workbook

[Pinaceous]

Hi All,

Is there anyway to create a dynamic workbook, so multiple users can input numerical information on that same workbook simultaneously?

For example, if I put 5 in cell A1 another user with the same titled opened workbook will see that change on their workbook and without that excel workbook saying it is a read only file.

Thanks,
Pinaceous