re: "I did do a little more research and found that with Office 2010 you can create a 'Shared' spreadsheet..."
The link that you provided is for saving a file to SharePoint site and using the spreadsheet via a browser. While SharePoint may be related to 2010 (I don't know for sure) "shared workbooks" have been around since the early days of Excel.
Where I work, we use shared workbooks, which are stored on a network drive, all the time with no lock-ups or data loss issues. We've been doing it for years.
My point is, the link you provided is not specifically related to creating or using shared workbooks, it's simply a place to store them and a web based app to use them. If the OP has 2007 (or even earlier) and access to a network drive (even on one of the user's PC) then they can create a shared workbook. You don't need 2010 to do that.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03