LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark McDonough
 
Posts: n/a
Default Help with Default Excel file and template

I'm having trouble getting the default "Book1" opening when starting Excel.

I made some changes to the default template book.xlt to include the option
"Accept Labels in Formulas" among a few other changes like number formats
and the like

Since doing this, it is the template file itself Book.xlt that opens up on
starting Excel and not Book1.

I notice also that by default there are actually 2 folders named Xlstart.The
folders a

c:\Documents\Settings\My Documents\Application Data\Microsoft\Excel\Xlstart

And

c:\Program files\Microsoft office\office11\Xlstart.

The book.xlt file is in the former directory. Now I do understand that
anything in that folder will open on starting Excel but if I remove the
book.xlt from there then where should it go. I haven't deleted it from the
Xlstart directory for fear that I won't get the desired result of having
Book1 open with my changes included.

There are no excel files of any kind in the Windows Start up directory. I'm
lost - what do I do?

Why can't Microsoft simply provide an option in Tools/Options etc to make
changes to the default file I'll never know, rather than having to delve
into the bowels of MS Office to look for some obscure file and make changes
to that.

Any help greatly appreciated.

Cheers

Mark.

Cheers

Mark


 
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 do I upload an Excel template file onto my Windows Smartphone Glenn Excel Discussion (Misc queries) 1 March 22nd 06 06:03 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
How do I fill an Excel template from a file Alejandro J. Formichelli Excel Worksheet Functions 0 March 21st 05 02:59 PM
Template in Excel prettytwin1 New Users to Excel 1 March 9th 05 09:22 PM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM


All times are GMT +1. The time now is 04:09 AM.

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

About Us

"It's about Microsoft Excel"