Office

  • Office 2007
  • Office
  • All forums
Question

How do I turn off Excel 2007 Compatibility Mode?

Applies To:

I have an Excel 2003 spreadsheet.  I have resaved it under a new name and under the new Excel 2007 file format.  The titlebar still says [Compatibility Mode] after the file name.

How do I turn off Excel 2007 Compatibility Mode?

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation
7 People had
this question

North Shore Girl

North Shore Girl

Was this helpful?

5

Votes

Answer

I've found that it only remains in compatibility mode until you re-open the workbook. I know it's a while since this was posted, but hope this helps someone!

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

antdos

antdos

Was this helpful?

2

Votes

Answer

Before uninstalling Excel 2007, consider to try the following steps:

1.    Open Excel 2007 > click on the Office orb

2.    Click on Excel Options > Save

3.    Select ‘Excel workbook’ from the ‘Save files in this format:’ dropdown at the top

4.  Restart Excel

 

Excel 2003 can also handle Excel 2007 files usingCompatibility Pack.

Sachin Shetty
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Sachin Shetty

Sachin Shetty

Was this helpful?

1

Vote

When you resave the file, it would save another copy of the Excel file. One file would be in .xls format and the other in .xlsx format. You need to open the .xlsx file and not the .xls file.
Sachin Shetty
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Sachin Shetty

Sachin Shetty

Was this helpful?

Yes, I tried this but it doesn't work and it still says "Comptiblity Mode".  But then again, I come to realize that so many things in Excel 2007 don't work. 

I'm now ensuring all of my Excel spreadsheets are in the 2003 file format so that I can uninstall Office 2007 and revert back to Office 2003.

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

North Shore Girl

North Shore Girl

Was this helpful?

2

Votes

Answer

Before uninstalling Excel 2007, consider to try the following steps:

1.    Open Excel 2007 > click on the Office orb

2.    Click on Excel Options > Save

3.    Select ‘Excel workbook’ from the ‘Save files in this format:’ dropdown at the top

4.  Restart Excel

 

Excel 2003 can also handle Excel 2007 files usingCompatibility Pack.

Sachin Shetty
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Sachin Shetty

Sachin Shetty

Was this helpful?

Is it possible to install Office 2003 and have it co-exist with Office 2007?  Or will there be a conflict because there are so many shared components??

I don't have time to deal with Excel 2007 anymore.  I need a reliable and productive tool to work with to get my job done and Excel 2007 isn't it.  It would be so great not to have to deal with the "RIBBON" anymore.  I'm also weary of having to use Google to figure out where to find functions that have been moved.

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

North Shore Girl

North Shore Girl

Was this helpful?

Yes you can install office 2003 with office 2007 installed. But there might be a conflict. To avoid this you can do a custom installed. Try uninstalling only Excel 2007 and install excel 2003.
 
1. Click Start - Control Panel - Programs and features - Highlight Office 2007 in the list and click Change.
2. Choose Add/Remove features - Click the arrow on Excel 2007 and choose Not available.
3. Click continue to uninstall Excel 2007
4. Insert the Office 2003 disc. Enter the product key > Accept the license agreement.
5. Uncheck all the applications listed except Excel.
6. Click Install.
 
This should install Excel 2003.
Sachin Shetty
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Sachin Shetty

Sachin Shetty

Was this helpful?

Consider using the interactive command reference to get urself familiar with Office 2007, I too thought the same way as you did when i used Office 2007, later i found that it is much ser friendly that the ealier versions.

 

 

SILVER HAWK If my suggestions are the possible interpretation of your solution, then mark this post as answered
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Silver-HAWK

Silver-HAWK

Was this helpful?

5

Votes

Answer

I've found that it only remains in compatibility mode until you re-open the workbook. I know it's a while since this was posted, but hope this helps someone!

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

antdos

antdos

Was this helpful?

If I had a dollar for everytime someone said "I don't have time to deal with XXXX anymore.  I need a reliable and productive tool to work with to get my job done" after poor and minimal attempts to troubleshoot an issue I'd be a rich man.  If you car had a strange intermittent knocking sound under the hood, and the mechanic had a hard time finding the source, you wouldn't just go buy another car.  Stop crying and use the ribbon till you know where they moved everything.  You may like it after you learn something about it.
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

qwertygetit

qwertygetit

Was this helpful?

If I had a dollar for everytime someone said "I don't have time to deal with XXXX anymore.  I need a reliable and productive tool to work with to get my job done" after poor and minimal attempts to troubleshoot an issue I'd be a rich man.  If you car had a strange intermittent knocking sound under the hood, and the mechanic had a hard time finding the source, you wouldn't just go buy another car.  Stop crying and use the ribbon till you know where they moved everything.  You may like it after you learn something about it.

Having just converted from Win XP/office 2003 at work, I can't see/feel any improvement in Win 7/Office 2007. And that is why MSFT is done. They've been making the same product for 30 years and it's still the Ford Pinto. Consumers have more and more alternatives every year. Stats don't lie, and the MSFT windows/office era is in its waning days. 
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

RyanHaverstock

RyanHaverstock

Was this helpful?

4

Votes

So easy. I hate that this answer was so far down in the thread, but thank you for providing it!
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

not_kalb

not_kalb
<< PreviousPage of 2 Next >>

Message marked as answers cannot be deleted

To delete this message, first unmark this message as an answer, then delete it.

Reason to remove escalation


Merge

Enter the thread ID of the thread you are merging into


Reply will be posted to a public thread

You are replying to a public portion of this thread. To reply privately, click Cancel, click the Private Messages tab, and Reply on that private message.

Don't show this message again

To report abuse, sign in or continue without signing in

Thank you.

Report abuse

Abuse type:

Details (optional):

Report abuse

Abuse type:

Details (required):
Enter the characters you see (required):
Type the numbers that you see in the picture.
Play audio and type the numbers that you hear.
Show a different picture.

Sign in

Hotmail, Xbox Live, Messenger, or msn accounts will also work.

Don't have one of the above accounts?

Signing in...
This page will automatically update after you are signed in.
If you are having problems, you can close this message and try to connect again.