If this is not possible, consider turning on Track Changes in Excel (an option available when you share the workbook) so that a change history is maintained. If the data contained in the workbook is extensive and it must be shared among multiple users, consider converting to a program that is designed for better data integrity in a multi-user environment, such as Access. If you "unshared" it, then only a single person can open the workbook at a time, which reduces complexity and decreases the chances of corruption. This leads to the first suggestion: don't share the workbook. All the problems were traced to the fact that a workbook was shared, and the problems went away when the sharing was turned off. Many folks have related experiences where data has become corrupted, information is overwritten, or data just outright disappears. This problem is, perhaps, a prime example of why many people refuse to trust shared workbooks in Excel. ![]() Still, she reports that there are times when the workbook data is simply erased wiped clean. ![]() In trying to track down the problem Karen did tests where she and her coworkers tried to open the file at the same time and save it at the same time, but all the tests left the data intact. ![]() Karen described a problem in which a shared workbook, stored on a company network, periodically loses all the data it previously contained.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |