Hello Dear This is excel 2007 Compatibility issue, Please contact or chat with Microsoft Specialist
https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1 Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 5:21 AM, Vinod N <nvino...@gmail.com> wrote: > 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: > > Re-created the Tracker in 2007 instead of just doing a Save As 2003 file to > 2007 file to overcome Compatibility issues. > Mapped the shared drive as a "Trusted Site" in Excel > 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 > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- 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.