2007 Excel shared file - data corrupts when more then one person changes or adds data.
We have a list we maintain in Excel to track projects we are bidding on, there are no formulas used or tables in this file. It is just text, dates and symbols. There are 13 columns and the number of rows increases daily as projects are added.
I recently shared this file to allow another user help keep it up to date. After the share was turned on we noticed that data was changing randomly, for example if a cell was left blank intentionally, the cell would later appear with data inserted
in it. Also, we use symbols or text in one of the columns depending on the projects status. I have noticed that the cells with text in them will revert to the wing ding (or symbol) randomly.
(Sidebar: I turned on the Share feature by selecting Review, Share Workbook and checking Allow changes by more than one user at the same time. This also allows workbook merging.)
We cannot figure out what is causing this to happen. The only other thing that is done to the file is a sort. I will sort the data using one of two columns, both contain dates.
Any suggestions or advice on how to keep this from happening will be greatly appreciated.
Linda Reed
Keys to the Problem 2007 Excel shared file - data corrupts when more then one person changes or adds data.
Use the System File Checker tool to repair corrupted or missing system files:
- Click Start.
- Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
- The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
- Type or copy paste the below command line into it without quotes:
- "Sfc /scannow"
Recommended Method to Fix the Problem: 2007 Excel shared file - data corrupts when more then one person changes or adds data.:
How to Fix 2007 Excel shared file - data corrupts when more then one person changes or adds data. with SmartPCFixer?
1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: Troubleshoot:2011 Word for Mac - My center alignment and all alignments for some reason, no matter what will move my whole paper instead of the highlighted text,[Solved] 2010 Microsoft trial version expired & now my Microsoft Starter version is gone too?????,How to Fix - 2007 Excel split panes?,How to Fix - 2010 Access Macro - Error?,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.