Hi Gurus, At my workplace, we use Excel 2007(Licensed). We maintain daily volume tracker(shared) and the same will be updated by my team members (8~10). They save the file systematically, one after another. As you are aware, if one user saves the shared file and at the same time another used saves the file, Excel will prompt Message such as "File is locked by User1" etc. So, after giving a gap of 3-5 seconds the second user tries to save the file again.
Excel 2007 automatically closes the current shared file and creates a temp file in place of the existing file. This is leading to a lot of time wasted in consolidation as we have piles of data. Further, if the user continues to work on the temp file without knowing that a temp file is created, the data saved by him is lost and thus is irretrievable. Earlier we were using Excel 2003 and we had no issues/problems.. but the day we started using 2007 we have started getting problems. We have taken the following step to curb the issue but the issue still exists: 1. Re-created the Tracker in 2007 instead of just doing a Save As 2003 file to 2007 file to overcome Compatibility issues. 2. Mapped the shared drive as a "Trusted Site" in Excel 3. Re-installed Excel in all the systems... Please help me Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
