Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,568
    Thanks
    141
    Thanked 12 Times in 12 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
    3,444
    Thanks
    166
    Thanked 651 Times in 619 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
    10,014
    Thanks
    423
    Thanked 1,608 Times in 1,452 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,942
    Thanks
    510
    Thanked 462 Times in 431 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,568
    Thanks
    141
    Thanked 12 Times in 12 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
    3,444
    Thanks
    166
    Thanked 651 Times in 619 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
    9,121
    Thanks
    64
    Thanked 1,125 Times in 1,048 Posts
    Why remove a command that was useful? Clowns!

    cheers, Paul

  8. #8
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,568
    Thanks
    141
    Thanked 12 Times in 12 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
  •