You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today's post is a little more...technical than I'm used to doing and I must say, right up front, that I did not come up with the answer on my own. Nope. Keep reading.
A reader named Tim from New York had an issue that, while wasn't a work stoppage issue, exactly, was driving him nuts nonetheless.
Tim, using Windows 7 and Office 2010, was used to working with (juggling, I'd say) many, many Excel spreadsheets open at once, and he wrote to me to tell me that when hovering over an Excel icon in the task bar, all Office 2010 programs with open files show the program icon only and then the file name. HOWEVER, he explained, Excel shows the icon AND "Microsoft Excel" AND the file name. For Tim this was an issue because he had so many files open that he was unable to see the names of all them from the task bar. He was seeing it like this (x100 because of all the files he had open):
Now, I tried it and was unable to reproduce this issue. When I opened several spreadsheets, all I saw was the Excel icon and the name of the spreadsheets (taking up WAY less room than Tim). Like this:
So here's the thing (and I found this out from a very helpful person who goes by the name "Pollardie" at Microsoft Answers): Tim had been opening a new instance of Excel for every spreadsheet instead of opening his many spreadsheets from within Excel, like I was doing. Pollardie explained that, telling Tim he should open his spreadsheets from within one instance of Excel if he wanted the program name to disappear vamoose, scram, disappear.
Problem solved? Well, yes and no. Technically, yes, but Tim wanted to open his spreadsheets any way in which he pleased, thank you (hey, a man has his reasons) and so for him, no, that didn't answer the question. And so he pursued it on Microsoft Answers, and both Tim AND Pollardie came up with a lovely solution.
Pollardie offered this bit of coding:
Code: Application.Caption = ActiveWorkbook.FullName
Yep, that worked. However, Tim wanted this code executed automatically, each time he used Excel. And he found a way. Here, see for yourself.
I want to thank Tim for taking the time to write me and to follow up with Microsoft Answers. I also want to thank that masked crusader at Microsoft Answers, Pollardie, whoever and wherever you are...
Moral of the story: If you don't ask, you don't get an answer.
Thank you Crabby for demonstrating the effectiveness of these blogs and the "Answers" forum in the quest for useful information and solutions. Two problems of a much lesser degree have been encountered since we corresponded on this matter and the "Answers" forum once again proved useful and effective. And now I'm able to very quickly skate in between 10 open Excel spreadsheets, each running independantly which allows me to to see and manipulate data from 4 or 5 disaparate sources across two widescreen monitors. It's like having 10 large reference books all opened and spread out on a large table at the library and now with the added convenience of being able to go directly to each book without having to look at the cover of the book for the title (my analogy for being able to see the filename in the taskbar as opposed to flipping through each open file).
Keep up the great work!
Yes! I'm glad that the three of us - you, Microsoft Answers, and me - were able to get this sorted out. Thanks for helping keep me honest and on track with what I'm doing here. And if you have any more neat tips and tricks, please send 'em! Thanks again--- Crabby