nouvelle
asked on
Excel Database
Hello
At work we have a local database, it looks like when someone adds something and save. When the other person from another workstation opens the excel database, the changes are not reflected.
Recently it happened with chart titles, that seem to disapear, once saved and opened from another workstation that the one it was saved to.
Any explanations, solutions?
PS: we use excel 2010.
Thanks
At work we have a local database, it looks like when someone adds something and save. When the other person from another workstation opens the excel database, the changes are not reflected.
Recently it happened with chart titles, that seem to disapear, once saved and opened from another workstation that the one it was saved to.
Any explanations, solutions?
PS: we use excel 2010.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But a shared workbook means that many users can save simultaneously. right? but we don't.
The idea of a "shared" workbook is that everybody can access ir and everybody can make changes which, of course, can be saved. Typically, the workbook would be in a location which is accessible to all who are supposed to have access.
You have put your finger on the critical spot. Which version will you get when you open the workbook while another user also has it open? Will you be able to see the changes which he has made but not yet saved? Then, as you are making changes, will the screen the other party is looking at change in real time? What about, if both users change the same cell, which version shall prevail?
In Excel change isn't necessarily modification of a cell's value. A "change" occurs even just by clicking somewhere because by doing so you change the ActiveCell and the Selection, both of which are vastly important for much of Excel's functionality. All considered, it is amazing that they very nearly got it to work. Unfortunately, there are some black holes in the system where data sometimes disappear in.
You have put your finger on the critical spot. Which version will you get when you open the workbook while another user also has it open? Will you be able to see the changes which he has made but not yet saved? Then, as you are making changes, will the screen the other party is looking at change in real time? What about, if both users change the same cell, which version shall prevail?
In Excel change isn't necessarily modification of a cell's value. A "change" occurs even just by clicking somewhere because by doing so you change the ActiveCell and the Selection, both of which are vastly important for much of Excel's functionality. All considered, it is amazing that they very nearly got it to work. Unfortunately, there are some black holes in the system where data sometimes disappear in.
Maybe you can rephrase your question..