Results 1 to 13 of 13
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    XLS in Template Folder (2000+)

    Hi again,

    Continuing on from the saga in the General Windows lounge about linking to a file from a template (see <post#=451165>post 451165</post#>), I had put the file (timecalc.xls) in the Templates folder on the network drive. Reasons were: I was already there for the template so didn't want to work with another folder as I'm testing, and I didn't think it would matter. That is, I had timecalc.xls in the folder where Excel templates are stored.

    To my surprise, when you opened Excel, you had timecalc.xls open in the Excel window. If you tried File-New, timecalc.xls would NOT show up, as I'd expect. I know you can have xls files in XLSTART and get this behavior but had never tried putting an xls into Templates until now.

    So 2 questions:
    - why is Excel opening with timecalc.xls when the file is in the Template folder? Is this "advertised" behavior?
    - if I had >1 xls files in the Templates folder, would all open when Excel is opened? If less than all the xls files open, how are the files to open selected? Needeless to say, I'm not anxious to try this out right now (people might be using Excel).

    TIA

    Fred

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XLS in Template Folder (2000+)

    Is your "templates" folder listed in tools - options as an "alternate startup directory"?

    Also File - new works with templates (.XLT) not workbooks (.XLS) have you tried saving it as a template?

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLS in Template Folder (2000+)

    If I put .xls files in my templates folder, they are NOT opened, but they ARE listed in the File | New dialog. Make sure that you have put the files in the User Templates folder, or in the Workgroup Templates folder; you can check their locations in Word (Tools | Options..., File Locations tab) or in RegEdit.
    Also make sure that you haven't set the location for 'At startup, open all files in' (in the General tab of Tools | Options... in Excel) to one of the template locations.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: XLS in Template Folder (2000+)

    Hans,

    Thanks.

    I'm confused about your first comment since it seems to apply to Word and this is an Excel problem. I didn't see anything in Excel's Tools | Options like a file location tab (but I'm looking at Excel 2003 here at home and will have to wait for work tomorrow to see if there is such a thing in 2000).

    Ditto your 2nd comment about the At Startup (wait until tomorrow) but at least I see that option in 2003.

    Fred

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: XLS in Template Folder (2000+)

    Steve,

    will have to wait for tomorrow at work to see if the template folder is listed as a Startup folder. But a question I'd have, based on some knowledge I have, is: would such a specification work in place of or in addition to any files in an XLSTSART folder? Sounds like it's "in place of" based on using "Alternate".

    As to your 2nd comment, I do NOT want the xls to act as a template. I just put the xls there for convenience of not having to create another folder on the network and probably forget it was there. At least I know where to look for the Template folder.

    But it sounds like Hans got the opposite result: the xls is part of the list with File | New.

    Thks.

    Fred

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLS in Template Folder (2000+)

    It is an addition to xlstart.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLS in Template Folder (2000+)

    All Office applications use the same User Templates and Workgroup Templates folders. Word is the only Office application that lets you view and modify the settings for these; that's why I mentioned Word. The User Templates folder you see in the File Locations tab of Tools | Options... in Word is also the User Templates folder for Excel; ditto for the Workgroup Templates folder.

    Excel has its own default startup folder (XLSTART) and a user-settable additional startup folder. These are NOT shared with other Office applications.

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: XLS in Template Folder (2000+)

    Hans,

    Thks for the info. I never really dug down to see which Office application had what.

    So it sounds like if I change the user or workgroup folder in Word, it changes these folders for all the other Office applications. Not sure I like the design. Having a startup for Excel is nice but not sure why there isn't the analogous folders for the other applications. Did MS design this? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Fred

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLS in Template Folder (2000+)

    Word does have its own startup folder (called STARTUP by default). The other Office applications don't, as far as I know, and I think I understand why: for Outlook and Access it wouldn't make much sense, and for PowerPoint it would be a nuisance if lots of files were being opened if you want to show a presentation.

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLS in Template Folder (2000+)

    Any folder listed as an alternate startup folder is in addition to the XLSTART folder.
    Legare Coleman

  11. #11
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: XLS in Template Folder (2000+)

    Legare, Hans,

    Thanks for the info.

    I found out at work today that the network admin had specified a folder in the Excel option for "at startup, open...". He thought that was how Excel on people's desks would know where the templates were.

    So it seems that Excel will open every xls (maybe xlt) in the XLSTARTUP folder as well as every file in the "at startup, open..." folder.

    But a very interesting thing about the path specification: it was "N:TemplatesExcel Templates" w/o the quotes of course. I didn't know one could leave out the first backslash after the drive. To think I've been typing it in all these years.

    Fred

  12. #12
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLS in Template Folder (2000+)

    Leaving the first backslash out means something different. If you put the first backslash in, it means to start at the root directory of the N: drive and then go to the Templates directory. If you leave the first backslash out, it means to start at whatever is the current directory on the N: drive and look for a Templates directory. They will work the same as long as the root directory is the current directory for the drive. You most likely do NOT want to leave out that backslash in this case as it could result in a failure if the current directory does not have a Templates subdirectory. It coudl also mean that you do not always get the same Templates directory if there is more than one on the drive.
    Legare Coleman

  13. #13
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: XLS in Template Folder (2000+)

    Thanks Legare.

    I think he wanted the slash to be in there. But he will probably end up deleting the entry anyway since it's not used the way he thought.

    Fred

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •