Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    'Personal' workbook (XP)

    More than a few of us on our LAN would like to get rid of that nuisance that Kaiser Bill calls "Personal.xls." I don't remember seeing this little pest in earlier versions of Excel. Surely it has a purpose (and I'd love to know what it is!), but I'll be sheep-dipped if I can see the value! I tried to find something about it in Excel Help, but I've had no success. Suggestions?

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

    Re: 'Personal' workbook (XP)

    I don't know why you find Personal.xls such a nuisance, and it certainly isn't new in Excel 2002 (XP). Excel has been using it to store macros that should always be available at least since Excel 95.

    See Legare Coleman's overview in <post#=272311>post 272311</post#>

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: 'Personal' workbook (XP)

    Personal.xls stores macros that you use all the time. It is very handy - though you can delete it if you wish!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Personal' workbook (XP)

    OK, Hans

  5. #5
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Personal' workbook (XP)

    Lucas,

    The PERSONAL.XLS should be hidden. Try Hiding it by selecting Windows / Hide from the menu.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Personal' workbook (XP)

    A-ha! Yes! That's it!

    Thanks, Chuck! As is so often the case, the answer was so darned simple!

  7. #7
    Lounger
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Personal' workbook (XP)

    Just to add my 2-bits worth,

    If you prefer not to show more than one instance of Excel in the taskbar,
    click on Tools | Options | View and put 'Windows in Taskbar' off.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Personal' workbook (XP)

    That's very interesting! I didn't know that. It appears you can do the same thing with Word. I usually like having all my open Word documents holding a spot on the taskbar. That way, I can use Alt + Tab to toggle between documents. But I can certainly see when I might want to take advantage of this selection.

    Thanks for sharing that information!

  9. #9
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Personal' workbook (XP)

    <P ID="edit" class=small>(Edited by Don_Sadler on 12-Jul-03 20:58. Operator error - I now have it.)</P>Okay - I agree with all about the personal.xls - however, I can't find mine. I am using excel xp (2002) and I have searched all over my hard drive for hidden files, system files, etc and no personal.xls. I do have add-ins, global macros, etc so I must have a personal.xls. Is there another name for this file? Never mind - I guess I didn't have any global macros.. I have now and I do have the personal.xls.

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

    Re: 'Personal' workbook (XP)

    There is no other name for Personal.xls. Addins do not use Personal.xls, and Addins can create global macros.

    When you install Excel, you do not automatically get a Personal.xls created. Have you followed the procedure in This Post to create a Personal.xls?
    Legare Coleman

  11. #11
    Lounger
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Personal' workbook (XP)

    Actually the 'Show windows in Taskbar' is a common setting throughout Office
    i.e., if you set it in Excel it will apply in Word & PowerPoint (Office 2000)

    It doesn't seem to apply to PowerPoint on my PC, though !
    I had to enable it separately from Tools | Options | View

    About switching between open Word files using Alt+Tab,
    you can also use Ctrl+F6 to get the same result.
    This combination works throughout Office.

    Point is, using Ctrl+F6 helps to keep your taskbar clutter-free.

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

    Re: 'Personal' workbook (XP)

    <hr>There is no other name for Personal.xls<hr>
    Not in English versions, anyhow. Dutch is something like persnlk.xls.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Personal' workbook (XP)

    Hello, Khushnood: Yes, I like the clutter-free taskbar, too. On the other hand, Alt+Tab is a one-hand operation--takes two to work Ctrl + F6. I've used both approaches, and each has its advantages. Thanks for the tip!

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

    Re: 'Personal' workbook (XP)

    In Excel, control-TAB also switches workbooks.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    Lounger
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Personal' workbook (XP)

    Hi Lucas,

    Yes, Ctrl+F6 does take two hands - unless you have BIG hands and like to work uncomfortably <img src=/S/alien.gif border=0 alt=alien width=14 height=15> !!!

    Also, Jan Karel Pieterse has suggested using Ctrl+Tab in Excel -- which is what I use all the time.
    I don't use Word / PowerPoint too often, so Ctrl+F6 is not so much of a pain when I use these packages <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Another suggestion - if you find yourself wanting to switch 'Windows in Taskbar' on & off, frequently,
    maybe you could record a small macro to do that in Excel, and assign it a shortcut !

    This line should do the trick in Excel
    Application.ShowWindowsInTaskbar = Not Application.ShowWindowsInTaskbar

    I tried - VERY BRIEFLY to look for a similar command in Word - and couldn't find it !
    Don't know if its there in Word at all, in the first place !

Page 1 of 2 12 LastLast

Posting Permissions

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