Solved

Excel Database

Posted on 2013-12-16
4
231 Views
Last Modified: 2013-12-17
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
0
Comment
Question by:nouvelle
  • 2
4 Comments
 
LVL 32

Expert Comment

by:ste5an
ID: 39723364
Excel is not a database. Thus, to what do you refer when you talk about "database"? You are also using the word "local". This normally means local to one user or local to one machine. So this may be the source of your problem.

Maybe you can rephrase your question..
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 500 total points
ID: 39723452
You seem to describe a shared workbook. Shared workbooks are a great idea but they are also a constant source of trouble. Read this.
Speaking in general terms, it is better to give everybody a template into which they can enter data, merge the data into a master workbook controlled by an administrator, and allow everybody ReadOnly access to the master. This doesn't sound as nice as what a shared workbook is described as but it has the advantage of working as expected.
Meanwhile, if you would like to have your shared workbook (if that is what it is) work as advertised it would be necessary to examine exactly what kind of changes are made in which sequence. It may be hard to provide a solution that can be guaranteed to work flawlessly, but there is a good chance of achieving some improvement.
0
 

Author Comment

by:nouvelle
ID: 39724052
But a shared workbook means that many users can save simultaneously. right?  but we don't.
0
 
LVL 14

Expert Comment

by:Faustulus
ID: 39725894
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.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
integer8 values 1 10
Convert .PDF 6 42
File size limit in SharePoint 2010 3 15
onOpen 14 41
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Creating and Managing Databases with phpMyAdmin in cPanel.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now