How can I turn off compatibility mode in Excel 2007?

  • Thread starter Thread starter HaJiggity
  • Start date Start date
H

HaJiggity

I'm working with more than 96,000 rows of data, and I know that Excel2007
will support that, but I need to turn off Compatibility mode? How do I do
this?
 
Hi HaJiggity

In Excel 2007 you be in Compatibility mode when you open a
Excel 97-2003 xls workbook.

Change the default file format to one of the 2007 formats and you not see it
 
I'm working with more than 96,000 rows of data, and I know that Excel2007
will support that, but I need to turn off Compatibility mode? How do I do
this?
Click to expand...
 
According to Excel help (F1), you can't manually turn on/off
compatibility Mode. Compatibility Mode turns on automatically whenever
you open a file from an earlier version of Excel. If you no longer want
to work in Compatibility Mode you can upgrade the file to the newer
format by saving it in that format. The next time you open that file it
will/should not automatically turn Compatibility Mode on.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
I'm working with more than 96,000 rows of data, and I know that Excel2007
will support that, but I need to turn off Compatibility mode? How do I do
this?
Click to expand...

My solution was to save the excelsheet WITH A DIFFERENT NAME. Then re-open, and save with the old name (.xlsx). Now the sheet is visible again.

Hope this works for all of you too.

regards
 
I'm working with more than 96,000 rows of data, and I know that Excel2007
will support that, but I need to turn off Compatibility mode? How do I do
this?
Click to expand...

tnx to all
 
I'm working with more than 96,000 rows of data, and I know that Excel2007
will support that, but I need to turn off Compatibility mode? How do I do
this?
Click to expand...

thanks Friends

let us see it is work ....
 
just simple to avoid compatiblity mode in excel 2007 open the file then open excel option the same when u have to save a file after opening that u will find convert option there just click on that then click two time ok when u asked it will convert and close the file by default and open also after doing this u will see that compatiblity mode has deen turn off
 
Back
Top