A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I turn off compatibility mode in Excel 2007?



 
 
Thread Tools Display Modes
  #1  
Old March 28th 08, 04:29 PM posted to microsoft.public.excel.misc
HaJiggity
external usenet poster
 
Posts: 1
Default How can I turn off compatibility mode in Excel 2007?

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?
Ads
  #2  
Old March 28th 08, 04:31 PM posted to microsoft.public.excel.misc
Bernard Liengme
external usenet poster
 
Posts: 4,393
Default How can I turn off compatibility mode in Excel 2007?

Save the file as *.XLSX (Xl2007 format) and reopen it
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"HaJiggity" > wrote in message
news
> 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?



  #3  
Old March 28th 08, 04:33 PM posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
 
Posts: 11,123
Default How can I turn off compatibility mode in Excel 2007?

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"HaJiggity" > wrote in message news
> 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?

  #4  
Old June 19th 09, 10:41 PM posted to microsoft.public.excel.misc
Danny
external usenet poster
 
Posts: 148
Default How can I turn off compatibility mode in Excel 2007?

THANK YOU THANK YOU THANK YOU!!!!!!!



"Bernard Liengme" wrote:

> Save the file as *.XLSX (Xl2007 format) and reopen it
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "HaJiggity" > wrote in message
> news
> > 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?

>
>
>

  #5  
Old August 9th 12, 07:55 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I turn off compatibility mode in Excel 2007?

On Friday, March 28, 2008 12:29:01 PM UTC-4, HaJiggity wrote:
> 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?


  #6  
Old November 11th 12, 04:07 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I turn off compatibility mode in Excel 2007?

Same problem with my case,but it is not workig as per solution given by you all.

On Friday, 28 March 2008 21:59:01 UTC+5:30, HaJiggity wrote:
> 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?

  #7  
Old November 11th 12, 05:59 AM posted to microsoft.public.excel.misc
GS[_2_]
external usenet poster
 
Posts: 3,128
Default How can I turn off compatibility mode in Excel 2007?

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


  #8  
Old December 7th 12, 10:56 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I turn off compatibility mode in Excel 2007?

On Friday, 28 March 2008 17:29:01 UTC+1, HaJiggity wrote:
> 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?


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
  #9  
Old December 19th 12, 10:29 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How can I turn off compatibility mode in Excel 2007?

On Friday, 28 March 2008 21:59:01 UTC+5:30, HaJiggity wrote:
> 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?


tnx to all
  #10  
Old April 4th 13, 07:37 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I turn off compatibility mode in Excel 2007?

On Friday, March 28, 2008 9:59:01 PM UTC+5:30, HaJiggity wrote:
> 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?


thank u so much
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off compatibility Checker in Excel 2007? MikeD1224 Excel Discussion (Misc queries) 2 December 17th 09 01:22 AM
Excel 2007 always opens in Compatibility Mode ksmek Excel Discussion (Misc queries) 6 December 21st 07 08:11 PM
how do I turn on/off "Design mode" in Excel 2007 easybuild Excel Discussion (Misc queries) 1 June 28th 07 07:58 PM
Best VBA test for 2007 in Compatibility Mode? [email protected] Excel Discussion (Misc queries) 2 May 3rd 07 03:19 AM
Excel 2007 and "Compatibility Mode" Chaplain Doug Excel Discussion (Misc queries) 2 February 6th 07 04:45 PM


All times are GMT +1. The time now is 04:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.