Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 18th 08, 05:18 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 16
Default EXCEL 2007 COMPATIBILITY MODE ISSUE

Hello,

Is there a way to prevent Excel 2007 from opening in compatibility mode for
each workbook you open? I have Office Professional 2007, Windows XP Pro OS.
This is what I have done so far:
I opened Excel and saved the default worksheet Book1 in the xlsx format. The
file was saved in C:\Documents and Settings\<user name\Application
Data\Microsoft\Excel\XLSTART
This does work if I have one instance of Excel open, but when I open a
second it shows Book1.xlxs is locked for editing and when I close that
warning box it opens with Book1 in compatibility mode.
Before I saved book1 the XLSTART folder was empty with the exception of my
macro personal file.

Advice and help is much appreciated!!

Thank you


  #2   Report Post  
Old September 29th 08, 03:01 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default EXCEL 2007 COMPATIBILITY MODE ISSUE

Hi,

The file in the \XLStart needs to be a template file. Open a copy of the
Book.xlsx file and choose Office Button, Save As, Book.xltx in the XLStart
folder. Then go and delete the xlsx version. By the way in this version of
Excel if you want the template macro enabled you need to save it with the
xltm extension.
--
Thanks,
Shane Devenshire


"Gemi" wrote:

Hello,

Is there a way to prevent Excel 2007 from opening in compatibility mode for
each workbook you open? I have Office Professional 2007, Windows XP Pro OS.
This is what I have done so far:
I opened Excel and saved the default worksheet Book1 in the xlsx format. The
file was saved in C:\Documents and Settings\<user name\Application
Data\Microsoft\Excel\XLSTART
This does work if I have one instance of Excel open, but when I open a
second it shows Book1.xlxs is locked for editing and when I close that
warning box it opens with Book1 in compatibility mode.
Before I saved book1 the XLSTART folder was empty with the exception of my
macro personal file.

Advice and help is much appreciated!!

Thank you



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I turn off compatibility mode in Excel 2007? HaJiggity Excel Discussion (Misc queries) 13 June 9th 14 12:38 PM
Compatibility Mode to Excel 2007 Jennifer Excel Worksheet Functions 4 September 16th 08 05:49 PM
EXCEL 2007 OPENING IN COMPATIBILITY MODE FARAZ QURESHI Excel Discussion (Misc queries) 1 May 5th 08 12:23 PM
Excel 2007, Compatibility Mode, and offline files Cliff Excel Discussion (Misc queries) 1 April 9th 08 02:02 AM
Excel 2007 always opens in Compatibility Mode ksmek Excel Discussion (Misc queries) 6 December 21st 07 08:11 PM


All times are GMT +1. The time now is 01:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017