Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Excel workbook names do not appear

    I am using Windows 10 and Office 2013

    When I Open several workbooks at once and select the Excel Icon on the task bar, the workbooks appears as Excel, but displays no names. When I select any of the workbooks, the name will then display for the workbook selected

    I would like to know how to overcome this, so that when opening several workbooks, the names will appear

    I have attached a sample of what the files likes like
    Attached Images Attached Images

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    Are you still getting your reported issue?
    On my Windows 10 and Excel 2016, I don't see what your thumbnail shows.
    If I open a dozen workbooks, and hover over the Excel icon on the taskbar, I see 'mini' versions of the files with the filenames clearly visible.

    zeddy

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Howard,

    How are you opening the files?

    Are you opening then in separate instances of Excel?

    Do you have your Taskbar options set to combine Icons?

    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,411
    Thanks
    447
    Thanked 405 Times in 377 Posts
    I wonder - if you change the color of your display, perhaps the text will show? Sometimes the background and text colors are the same, which results in the text being "hidden", because it blends in with the background color.

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Hi Guys

    Thanks for your responses

    I use a Macro to open 18 workbooks. It is only when I use a macro to open the workbooks that I encounter this problem. Not sure why they would cause the problem of workbook names not being displayed when hovering over the Excel icon on the taskbar


    Howard

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    If you were still using Excel2010 you could open your 18 workbooks without a macro!

    Before Excel 2013, when you are working with the same group of files each day you could save time by saving the files as a 'workspace group' as follows:
    1.Open all the workbooks you want to work with, and arrange as required.
    2.Click the View tab.
    3.Click Save Workspace in the Window group.
    4.Enter a name for the group, and click Save.

    To open the group (i.e. all the workbooks in the group), just open the .xlw file you gave in step 4. e.g. open file named "zeddy-stuff.xlw"

    The workbooks in the group are still separate files. You can open and close them individually, as you normally would. However, Excel also saves a reference to the workbooks as a group now, using the xlw extension.

    The Save Workspace command is no longer available from Excel 2013 onward, but you can still open a workspace file (*.xlw) that was created in an earlier version of Excel.

    Just thought others might be interested to know this.

    zeddy

  7. #7
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,199
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Why remove a command that was useful? Clowns!

    cheers, Paul

  8. #8
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Thanks for the valuable info. The workspace is very useful. One wonders why MS would remove this from later versions

Posting Permissions

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