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

http://www.techrepublic.com/blog/window-on-windows/how-do-i-restore-a-sql-server-database-to-a-new-server/454

Sorry this not for you

thought so, lol

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

This will be used as default file for any new excel document that you create

>>"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!

Guess you meant word!! :-). Word it is Normal.dotm below

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

@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.

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! ;)

@Rorya - My bad. The question is clearly for excel and not word!! :-) I got confused..

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.

"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.  

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.

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

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?

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