Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to change Excel default file?

26 Aug 2014   #1

Windows 7 Home Premium 64bit
How to change Excel default file?

Windows 7 Home Premium, 64 bit, SP1, Office 2010.

I want the default Excel file to be slightly different from the default ‒ different font and size centered vertically and different row and column sizes, nothing major. I created a new template with the name “Book.xltx” and saved it in C:\Program Files\Microsoft Office\Office14\XLSTART. Now when I open Excel this new template opens and I do my happy dance. Unfortunately, this causes a couple of unwanted changes.

First, if I want to open an existing file by clicking the “File” tab, I don’t get the “Recent” page showing my recent files, I get the “Info” page showing the information for file “Book1.” That is not what I wanted to happen.

Second, if I make no changes to “Book1” but instead open a recent file, make changes, save and close the recent file by using the “Close” button in the upper right corner; Excel doesn’t close. Only the window with the recent file closes leaving the window with “Book1” still open. I have to click the close button a second time to exit. This also isn’t what I wanted to happen.

I successfully modified the default Word file, although the method was not the same (?) and neither of these issues occurred with Word.

Is there any way I can get Excel to behave the way it use to but have my preferences in the default “Book?”

Thank you.

My System SpecsSystem Spec
26 Aug 2014   #2

Windows 7 Pro

Hi GordonS and welcome to Seven Forums,
Can you try and delete all the custom settings you made to your excel and see if that helps:
Open regedit in run and delete those registry keys:
Then you must restart Excel and a repair operation is triggered to set the settings to the default settings.
Hope that helps.
My System SpecsSystem Spec
26 Aug 2014   #3

Windows 7 Home Premium 64bit

Hi midou,

Your suggestion sounded reasonable so I gave it a try and it did get rid of all my settings -- no biggie, I still have a good image to fall back on.

I forgot to mention that if I just remove Book.xlts from C:\Program Files\Microsoft Office\Office14\XLSTART Excel works just fine except that I don't have my preferred starting point.

I really don't want to give up now. I'm getting close. It took a few hours and many tries to get this far. Getting Word to start with my preferred file was almost as frustrating but everything works as expected there.

My System SpecsSystem Spec

26 Aug 2014   #4

Windows 7 Pro

My System SpecsSystem Spec

 How to change Excel default file?

Thread Tools

Similar help and support threads
Thread Forum
Dump File - Change Default Location
How to Change the Default Memory Dump File Location in Windows This tutorial will show you how to view and change the default location where to save a memory dump file at when you get a BSOD in Vista, Windows 7, and Windows 8. You must be logged in as an administrator to be able to do...
How to change the default file manager?
I've been using XYPlorer as a replacement for the standard Windows file manager for a while, and I want to use it exclusively. It has a lot of features, but a primary advantage is that you can open several folders at once with a tabbed interface and just one instance of the file manager, rather...
Change default icon on file type
I'm trying to figure out a way to change the default icon for a specific file type (ie: change .vbs icon to a custom icon). I've been doing some searching on this forum and I've come across some ways to change default icons but they all seem to involve going through the registry. Is that really the...
How do I change the default File Upload directory?
When I click a button to upload a file, I'm prompted with the File Upload window. Automatically, it defaults to the Desktop. I wish to change this to My Documents. My Internet searches result in a bunch of spam about changing file directories inside various software not relating at all to what I...
Browsers & Mail
Excel File and Program default association problem (registry looks ok)
Everything looks okay under the registry (I think) and assoc shows provides the correct output. When I try to manually edit this under the control panel, it will not let me choose "EXCEL" it will not let me choose that file. Does anything stand out as being out of help here? > assoc .xlsx...
Microsoft Office
How do I change pinned .txt file icon to default.
How do I change pinned .txt file icon to default. I've pinned some of my text files on Notepad for faster access, but it is very annoying to see that old generic notepad icon. It wasn't like that before. I don't know how it happened. I've already tried rebuilding IconCache.db, restarted the...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 13:04.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App