I need some advice. You may have seen my other thread. I'm getting back into developing spreadsheets for work. I have never
made one for multiple users, a shared one, that is.
It's basically a database of projects, each project being
assigned to a particular salesperson, one row per project, but all together on the spreadsheet, so the boss can see all of
the projects, total them, make sales forecasts, charts, etcetera.
I figure my spreadsheet will sit on one of the
company servers, and each user will open it over the network connection. He'll add and update his projects and then exit from
the spreadsheet. It is my understanding that only one user can make changes to a particular spreadsheet at one time. Maybe I
am wrong. This would be a downside.
But if I am right I had the second idea of having the spreadsheet on the
server, like in the first example, but having it set up so that when a user opens it up, the spreadsheet recognizes the user
and gives them a copy of the worksheet, loaded with their projects only. They can edit their projects, add new projects,
whatever, at their leisure, as it would only be a copy, and it would reside on their computer. When the spreadsheet is
closed or a button such as "UPDATE" is hit, the main spreadsheet would sync his projects back in, with the new
I like the second idea better but I know it will be more programming-intensive but the users would like it
Any advice or suggestions??