Solved

Excel overwrite problem

Posted on 2013-06-06
5
183 Views
Last Modified: 2013-10-30
I have a school network with several office users. Just recently the users cannot overwrite an excel file or a word file on a network drive. They can create a new file and save it OK. The files were saved as xls or doc, probably from Office 2003. When the files are opened and modified, they cannot be saved with the same name (overwritten). The users are using Office 2007 or Office 2010. Each time they try a tmp file is created. I understand that office saves the overwrite file as tmp then renames it to the original name when it completes. The users can save the files OK if they change the extension to xlsx or docx. They can then delete to old xls or doc files. Why does it not work like it did before?

I have googled and found others have the same problem. Of course, the first question is ... what has changed on the network? Several things have changed in the last week, but others with the same problem did not have these changes. I originally had 3 DCs; one 2008 and two 2008 R2. I ran dcpromo on the 2008 dc and removed it from the network. DHCP is on one of the 2008 R2 DCs. The removed DC had been running WINS. I changed the options in the DHCP scope to switch WINS to one of the remaining DCs.

The files are on a mapped drive on a 2003 server. I plan to move the files to another shared drive on a 2012 server, but have not done that yet. Of course, I am making the updates and changes during the summer break.

Although the users have a workaround, I would like to know what can be done to fix the problem. Any help would be appreciated. Thanks in advance.
0
Comment
Question by:old_hickory
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39230452
Can they do a SAVE AS and change the file type to Excel 1997-2003 (.xls)

mlmcc
0
 

Author Comment

by:old_hickory
ID: 39230527
I will not be back onsite until Tuesday. I think the answer is no, but I need to verify that.
0
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 39246633
Do the files open as read-only? I get this problem occasionally when a network backup hasn't completed and the files are locked.
...Terry
0
 

Author Comment

by:old_hickory
ID: 39248023
No. They do not. It only happens with the xls files. not the xlsx. Wouldn't they all be locked if it were caused by a backup in progress? Since I posted this, I have moved the files to a 2012 share. Since I did that there have been no problems. This confuses me even more.

Thank you for your post.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

707 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