Results 1 to 10 of 10
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Excel 2016 default book isn't working

    I have a workbook, book.xltx in the folder C:\Users\CWBillow\AppData\Roaming\Microsoft\Excel\ XLSTART.

    If I go there and right-click and open it, all looks fine. But if I just start Excel, the template isn't being used. What am I doing wrong here?

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    Hi CWBilow
    Is that folder listed as the Excel Startup location listed in Trusted locations?

    In my 2013 I see locations for a default User Startup and an Excel Startup.

    My Excel Start up is off Program Files\Microsoft Office\Office14\XLSTART

    Cheers
    Geof

  3. #3
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Trusted location?

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    Hi
    Does this article help?

    Geof

  5. #5
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    I have a sheet that I set up, Book.xltx. I saved it to my desktop, but then copied it to "C:\Users\CWBillow\AppData\Roaming\Microsoft\Excel " . I right-clicked it and it was the file I had set up.

    But, when I start Excel, Excel has it's own starting worksheet, and I dunno where it is getting it from.

    I had done this easily in Excel 2010. I don't know why this is such a problem.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  6. #6
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Not a lot of new info there, Geof. I can sort of get along by formatting a sheet the way I want it, and storing it as read-only in XLSTART. Then when I save it I will be forced to rename (and relocate) it.

    That works, sorta, but it is hard to believe that MS didn't allow for the starting template as they always had in the past.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  7. #7
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Geof, I just went back to be sure. C:\Users\CWBillow\AppData\Roaming\Microsoft\Excel\ XLSTART\ is listed in the Trusted locations, and, the file that is in that folder is formatted correctly, and is NOT AT ALL like what Excel opens up with on its own.

    Where is Excel pulling that file from, I wonder?

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    Hi

    Sorry but I am in the same boat as you.
    And I have my head in the hunny jar reflecting on judgement. I am going down to the creek to toss sticks and think some more.
    Geof

  9. #9
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    It just absolutely drives me batty that something I have done and redone for, oh, at least ten tears is totally evading me. Of course there is always he chance of a bug, or that Microsoft changed its methods, but why and how then become the questions.

    I don't have a creek to got to since I am in the desert. Ah me...

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  10. #10
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,370
    Thanks
    78
    Thanked 12 Times in 11 Posts
    I found the template location. It is C:\Users\CWBillow\AppData\Roaming\Microsoft\Excel\ XLSTART, just like in Excel 2010. I don't know why it wasn't working before, but I went back to my "pre-Office 2016" image backup, and started over, and this time it worked fine.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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