Solved

excel 2007 - how do I set a new blank document to default to landscape and not portrait when opened?

Posted on 2011-03-23
17
263 Views
Last Modified: 2012-05-11
excel 2007 - how do I set a new blank document to default to landscape and not portrait when opened?
0
Comment
Question by:gpersand
  • 7
  • 5
  • 2
  • +2
17 Comments
 
LVL 5

Expert Comment

by:Angelgeo
ID: 35196973
0
 
LVL 5

Expert Comment

by:Angelgeo
ID: 35196980
Sorry this not for you
0
 

Author Comment

by:gpersand
ID: 35196992
thought so, lol
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35197021
Save your template at below file location and name it as "Book.xltx". Your drive could be different and replace user name.

D:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLSTART
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35197027
This will be used as default file for any new excel document that you create
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35197053
>>"This will be used as default file for any new excel document that you create "

Unless you use the Office button - New - Blank workbook option to create a new file, in which case all templates are ignored!
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35197056
Guess you meant word!! :-). Word it is Normal.dotm below

D:\Documents and Settings\jignesh.thar\Application Data\Microsoft\Templates\Normal.dotm
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35197061
@rorya - I didnt know that clicking Office Button ignores it. I always used Ctrl + N so didnt know that that. Thanks for poitning it out.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35197070
I use Ctrl+N or the New button on the QAT so it's not an issue for me, but it is something to be aware of!

PS Where did Word ever come into this? It's in the Excel zone and the question mentions Excel 2007 twice! ;)
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35197086
@Rorya - My bad. The question is clearly for excel and not word!! :-) I got confused..
0
 

Author Comment

by:gpersand
ID: 35197088
yes the WORD bit confused me also. Im just waiting for my user to get off the phone so I can testjigneshthars solution and award but im leaving the office at 10am for a branch visit so may have to update tomorrow. Thanks for the help experts.
0
 

Author Comment

by:gpersand
ID: 35205206
"Save your template at below file location and name it as "Book.xltx". Your drive could be different and replace user name.

D:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLSTART"

I have tested this now but unfortunately it did not work.  
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35205412
Your problem may be due to using Excel 2007 and Excel 2003 in side-by-side installations.  See http://support.microsoft.com/kb/930480 for work-around.

Try clocking on the Office Button at the top left of the window.  Then
at the bottom of the pop-up window, under the recent documents list,
there is a button for Excel options.....click that button.  Then on
the left, click on Add-in's.  At the bottom of the Add-in page there
is a "Manage" drop down.  Select Disabled Items from the "Manage" drop
down and hit GO.  If Book.xlst appears there, enable it again and
it will load when Excel starts up.

0
 

Author Comment

by:gpersand
ID: 35205652
Tried the above but no luck either. There were no disabled items..
I can confirm however that previously  Office 97 was on the pc and was upgraded to Office 2007.
Add and remove programs shows both Office versions. should I remove office 97 as its not being used??
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 35205819
Was location like "C:\Documents and Settings\$User Name\Application Data\Microsoft\Excel\XLSTART" already existing or you had to create one? What are other files in this folder?

I dont see any harm in uninstalling 97 (In worst case, it might cause problem with 2007 install which might require repair). When office is upgrade - typically you get an option to keep previous version (with both 97 and 2007 co-existing).

Can you try keeping any other excel file in this folder and see if it opens when you start excel?
0
 
LVL 1

Accepted Solution

by:
veasnamuch earned 500 total points
ID: 35212704
You can try this  way,

I think normally Microsoft Office 2007 XLSTART is default stored at C:\Program Files\Microsoft Office\Office12\XLSTART
I have succeded test this, so you can try it either.

First you need to open a blank Excel 2007 file, and delete all sheet exept Sheet1(Right click on Sheet2 and Sheet3 then select Delete). Then go to the Page Setup group in the Page Layout tab. Adjust margins, change the page orientation and make any other changes you want to apply to default Excel workbooks.
Hold CTRL key and drag on Sheet1 to make a copy, and drop to its closer sheet to creat new for Sheet2, and Sheet3.

Then select Save As from the Office Button in Excel 2007. In the Save In location box,
go to the file path of the xlstart{C:\Program Files\Microsoft Office\Office12\XLSTART} folder on your computer.
Enter the file name As Book.xltx. In the Save As Type drop down, select Template. Click Save.

  Then close all Ms Excel file, and reopen the new blank file, you will see all your previous configuation to the template is on your serve.

Veasna Creation phase Save phase
0
 

Author Comment

by:gpersand
ID: 35239969
i am still working on this but the users has not let me use his machine as hes soo busy he says. As soon as I get a chance I will update. Hopefully today
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now