Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
I recently installed Excel 2007 and notice that many of my files are running
in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
"Jerry" wrote in message
... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? Excel 2007 default file type is .xlsx - prior versions are .xls - when you open an xls file in excel 2007, it runs in compatability mode (AFAIK....) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
The file format in Excel 2007 differs from that in the earlier versions. If
you open an existing XLS file made with Excel 2003 (or earlier) then Excel 2007 automatically switches to compatibility mode so enable it to open the older format. A newly made Excel 2007 file will generally have the extension XLSX. Such a file will open in native (non-compatibility) mode. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jerry" wrote in message ... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
I have saved the file as an Excel 2007 file. It now has the .xlsx extension
but still says that I am in Compatibility Mode. I do not understand why that is still the case. What should I do to not have it in compatibility mode any longer? "Bernard Liengme" wrote: The file format in Excel 2007 differs from that in the earlier versions. If you open an existing XLS file made with Excel 2003 (or earlier) then Excel 2007 automatically switches to compatibility mode so enable it to open the older format. A newly made Excel 2007 file will generally have the extension XLSX. Such a file will open in native (non-compatibility) mode. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jerry" wrote in message ... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
"Jerry" wrote in message ... |I have saved the file as an Excel 2007 file. It now has the .xlsx extension | but still says that I am in Compatibility Mode. I do not understand why that | is still the case. What should I do to not have it in compatibility mode any | longer? <snip You didn't fool Excel 2007, it knows what you did :-) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
Jerry
Try closing the file and re-opening -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Jerry" wrote in message ... I have saved the file as an Excel 2007 file. It now has the .xlsx extension but still says that I am in Compatibility Mode. I do not understand why that is still the case. What should I do to not have it in compatibility mode any longer? "Bernard Liengme" wrote: The file format in Excel 2007 differs from that in the earlier versions. If you open an existing XLS file made with Excel 2003 (or earlier) then Excel 2007 automatically switches to compatibility mode so enable it to open the older format. A newly made Excel 2007 file will generally have the extension XLSX. Such a file will open in native (non-compatibility) mode. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jerry" wrote in message ... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
That got it. Thanks Nick!
"Nick Hodge" wrote: Jerry Try closing the file and re-opening -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Jerry" wrote in message ... I have saved the file as an Excel 2007 file. It now has the .xlsx extension but still says that I am in Compatibility Mode. I do not understand why that is still the case. What should I do to not have it in compatibility mode any longer? "Bernard Liengme" wrote: The file format in Excel 2007 differs from that in the earlier versions. If you open an existing XLS file made with Excel 2003 (or earlier) then Excel 2007 automatically switches to compatibility mode so enable it to open the older format. A newly made Excel 2007 file will generally have the extension XLSX. Such a file will open in native (non-compatibility) mode. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jerry" wrote in message ... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compatibility Mode
Jerry
It is a little strange that you have to do that, but 'mode' is determined on opening and fixed it appears. Glad it worked for you -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Jerry" wrote in message ... That got it. Thanks Nick! "Nick Hodge" wrote: Jerry Try closing the file and re-opening -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Jerry" wrote in message ... I have saved the file as an Excel 2007 file. It now has the .xlsx extension but still says that I am in Compatibility Mode. I do not understand why that is still the case. What should I do to not have it in compatibility mode any longer? "Bernard Liengme" wrote: The file format in Excel 2007 differs from that in the earlier versions. If you open an existing XLS file made with Excel 2003 (or earlier) then Excel 2007 automatically switches to compatibility mode so enable it to open the older format. A newly made Excel 2007 file will generally have the extension XLSX. Such a file will open in native (non-compatibility) mode. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jerry" wrote in message ... I recently installed Excel 2007 and notice that many of my files are running in Compatibility Mode. What does this mean and how do I stop it from doing that (if I even want to)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best VBA test for 2007 in Compatibility Mode? | Excel Discussion (Misc queries) | |||
Excel 2007 and "Compatibility Mode" | Excel Discussion (Misc queries) | |||
What does compatibility mode mean | Setting up and Configuration of Excel | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |