?
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
Medium Priority
?
275 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: 35196980
Sorry this not for you
0
 

Author Comment

by:gpersand
ID: 35196992
thought so, lol
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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 2000 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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

840 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