Solved

How do I save a document in compatibility mode?

Posted on 2010-09-07
6
541 Views
Last Modified: 2012-05-10
Hi ~

I have a 2003 excel file and just recently upgraded my office suite to 2007.  When I open a 2003 network shared file in 2007 and try to save it back to 2003 version, I get the following error:
"File <xxx> is currently in use.  Try again later."

I know that I'm the only one using the file, so it isn't being locked by another user.  I don't want to save it with the 2007 version because I still have clients that still use the 2003 format.

Any ideas on how to solve this problem?
0
Comment
Question by:gcastong
6 Comments
 
LVL 7

Expert Comment

by:thakurdinesh
ID: 33623874
You just need to change the default file save format to .doc instead of .docx

Open the Option of word 2007, click on the save, then click on the "Word 97-2003 Document .doc" from drop down save file format. apply the changes. close the word, open with any file, it wont ask you to save as xml.. same thing you can apply with excel as well..

Hope this will help you..
0
 
LVL 13

Expert Comment

by:gbanik
ID: 33624204
Excel 2003 format = .xls
Excel 2007 format = .xlsx or .xlsm

So when u open a .xls file (2003 format) in Excel 2007 and try to save it, by default it gets saved in 2003 format itself... you dont have to explicitly save it using the 2003 format. Hence the exception, because you are trying to "SaveAs" the same file name (currently open) rather than "Save" onto itself.

In conclusion, if the file extension is .xls, whether you use Excel 2003 or Excel 2007 the saved file will be in Excel 2003 format.

... Enjoy!

0
 
LVL 45

Accepted Solution

by:
patrickab earned 63 total points
ID: 33625149
gcastong,

>When I open a 2003 network shared file in 2007 and try to save it back to 2003 version, I get the following error:
"File <xxx> is currently in use.  Try again later."

This is such a regular question here on EE that I have a standard text on shared Excel files:

Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.

To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.

I realise it seems odd that MS would have an unreliable feature in Excel but I'm afraid that's the way it is. If you must have simultaneous access then it would be wise to use a proper database.

For Office 2007:  Office Button > Excel Options >Popular tab >User name

Patrick
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 62 total points
ID: 33626752
Amplifying what my colleague Patrick has to say, it is only a small exaggeration to say that there are only two kinds of shared workbooks: those that have become corrupted, and those that soon will be :)

On a more serious note, the only use for shared workbooks that most Experts here will even tentatively endorse is to enable "track changes", but even then none of the top Experts here recommend allowing >1 user at a time into the shared workbook.

Patrick
0
 

Author Closing Comment

by:gcastong
ID: 33685542
It was great advise and kept me informed.  I only wished that there was a solution to the problem.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 33685799
gcastong - Thanks for the grade and points - Patrick
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now