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
Solved

How do I find the compatibility Errors in Office 2010 file?

Posted on 2011-03-23
7
289 Views
Last Modified: 2012-05-11
Greetings,
I have a file running in compatibility mode and I need so see why. What's not compatible? I know the compatibility box comes up when saving sometimes but is there a way to bring that up on-demand?

Thanks for any help.
0
Comment
Question by:dtw404
7 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35201682
Doesn't that happen only when you open .xls (Excel 2003) files? This happens until you save those files in Excel 2010 format (.xlsx).

jppinto
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35201698
>>>I know the compatibility box comes up when saving sometimes but is there a way to bring that up on-demand?

In Excel 2010, On the File tab, click Info, click Check for issues, click Check Compatibility, and then check the Check compatibility when you save this workbook box.

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35201702
Sorry didn't see your post jp. Was testing the above in Excel 2010.

Sid
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35201715
dtw404: More information can be found on the MS Site.

Title: Working with the Compatibility Checker in Excel 2007 and Excel 2010
Link: http://msdn.microsoft.com/en-us/library/gg132972.aspx#odc_xl14_ta_ExcelCompatibilityChecker_CompatibilityCheckerExcel

Hope it helps :)

Sid
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35201793
as far as I know, in Excel 2010, you can go:
Office button / Info / Manage Versions...

but the Compatibility Options only show there when you have an XLS (or any 97-2003) file open, which seems to be your case.
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35201804
sorry, not Office button, they renamed it to File in Excel 2010.
0
 

Author Comment

by:dtw404
ID: 35201882
The Question should be phrased "How do I engage the compatibility check for older files in Office 2010?"

Thanks for all the remarks!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 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