Taskbar group buttons unchecked and Excel



  • 1. "solver" add-in
    The software I received from a friend does not contain the "solver" add-in. Anyone know how I go about getting this?
  • 2. How can I retrieve macro recording toolbox?
    I am using Excel 2000 & after recording a new macro in a worksheet I closed it with X instead of stop button. Since then the macro toolbox does not appear when trying to record a new macro. Can anybody please help me to recover it/
  • 3. Scanning down a column
    I want to scan down a data series in a column and look at the value of each cell in cell G4. I can do this in a Macro, but I would like to do it with formula using Function Key F9. e.f. Formula in Range("G4") = "=A1" will advance to Range("G4") = "=A2", Range("G4") = "=A3" and so on with each calculation. To begin, I will have Range("G2") = "=G1 + 1" : Range("G1") = "=G2" which are circular. Formula in Range("G4") will look something like Range("G2") = "=A" & Range("G1") Thanks
  • 4. IF Function too Large
    The function below is a partial version of the correct one; I will exceed the allowed characters for the field (too many arguments). I notice I am using different arguments which could be combined as a range: IF(C16=5:7 for the same results, in other words 5, 6 & 7 all = E20 as a result. =IF(C16=5,E20,IF(C16=6,E20,IF(C16=7,E20,IF(C16=8,E21,IF(C16=9,E21,IF(C16=10,E22,IF(C16=11,E22,IF(C16>11,E23,0)))))))) How can I build this function combining criteria as a range for a common result? -- Thank you, Trying Hard
  • 5. How do I select the nearest date from a ranges of dates?
    Hello, suppose you have a range of dates and you would like to select the nearest future date. For exemple, range of possible monthly repayment dates goes from 1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first next possible redemption date should be 1st March. On 24th June, the first possible redemption date should be 1st July. My question is, is there anybody who can explain me how to program such a formula in excel? Many thanks in advance, Gerrit

Taskbar group buttons unchecked and Excel

Postby VGlzaGE » Fri, 18 Nov 2005 00:11:05 GMT

When I open several files at one time in Excel, the taskbar only shows one 
file open, even though I have the taskbar group box unchecked. In order to 
show each file I have to open each file individually. How can I eliminate 
multiple steps to show each Excel file in the taskbar?

Re: Taskbar group buttons unchecked and Excel

Postby Dave Peterson » Fri, 18 Nov 2005 00:17:46 GMT

In xl2k (and higher), you can use:

tools|options|view tab|check windows in taskbar.


Dave Peterson

Re: Taskbar group buttons unchecked and Excel

Postby VGlzaGE » Fri, 18 Nov 2005 01:01:05 GMT

If in Excel, I go to file|open|and ctrl or shift several files, only one file 
shows in the taskbar, even if I check the windows in taskbar. Any other 

Re: Taskbar group buttons unchecked and Excel

Postby Dave Peterson » Fri, 18 Nov 2005 01:48:57 GMT

I'd double check the number of workbooks/windows that are open.

Look under Window in the worksheet menu bar.  If you only see one name at the
bottom of that dropdown, then you only have one workbook open.

If you see multiple names at the bottom, double check that setting
(tools|options|view tab).  If you're using xl2k and shared workbooks, it may be
getting toggled back without your knowledge/permission.  This was fixed in

What version of excel are you using?


Dave Peterson

Re: Taskbar group buttons unchecked and Excel

Postby VGlzaGE » Fri, 18 Nov 2005 03:56:24 GMT

I am using Windows XP and Excel 2003. 

I have rechecked the settings in options and the verified that the taskbar 
isn't grouping them. I also have checked that multiple files are open, and in 
fact the only way I can get into the files is by the windows dropdown. If I 
open each file individually instead of openning them all at once, then they 
all show up on the task bar.

Re: Taskbar group buttons unchecked and Excel

Postby Dave Peterson » Fri, 18 Nov 2005 04:05:39 GMT

First, you can also use ctrl-tab and ctrl-shift-tab to cycle between open

But I'm confused.

You've checked tools|options|view tab|windows in taskbar.

And you've changed the taskbar setting itself (I read your first post like you
rightclick on Windows start button|properties|taskbar tab

Uncheck Group similar taskbar buttons.

(if you've done all this, then I don't have another guess.  I use xl2003 and
winXP home and it works fine for me.)


Dave Peterson

Similar Threads:

1.Taskbar "Group similar taskbar buttons"

I first thought that this was happening only to me and that it was related to 
my profile somehow being "damaged".  Now, since I've deployed Office 2003 to 
others, they are reporting the same problem.  The problem is this;
If you have the option selected to "Group similar taskbar buttons" and an 
app (let's say IE) has several groupings, sometimes (can't reproduce the 
problem) I can no longer access this grouping.  I click on the IE grouping in 
the taskbar and nothing happens.  I can maximize the other apps that have 
only one "instance", but every app that has a grouping doesn't expand.  I can 
Alt+Tab to get to these apps, but can't do it in the taskbar anymore.  I have 
to logoff and back on to get back to "normal".  Also, when I log back on, the 
QuickLaunch bar is deactivated and I have to go and re-activate it.  Any 
ideas?  Running Windows XP w/SP2 and Office 2003 w/SP2.

2.excel buttons grouped on taskbar

3.Office XP on W2K 'Group similar taskbar buttons'

I have Office XP running on windows 2000. All my Word 
documents open using the same group in the taskbar (same 
with Excel). Does anyone know how I can change this 
behaviors and make sure that each instance of the 
application will have it's own task button. I found an 
option only in Windows XP, but not 2000.

4.Excel Taskbar button disappears when excel is minimized

I have been experiencing this issue for a few months now with excel 2003.

When I minimized excel, the taskbar button disappears and I am unable to see 
the open worksheet anymore. If I open up Task Manager, under applications I 
can see that excel is still running but in order to use it I must select it 
and then switch to that task. Is there a way to make excel stop disappearing 
from the taskbar? Although I can get back to my workbook it is starting to 
become frustrating that I must use the task manager. 

Excel is the only program experiencing this error. All other office programs 
work great.

Any suggestions here will be greatly appreciated


Todd Forbes
Northwest School Division
Saskatchewan, Canada

5.Taskbar not grouping Excel

My XP professional recently stopped grouping excel files, although it groups 
all others. Also, alt-tab does not show separate files when multiple 
workbooks are open, only a single instance of Excel.

Any suggestions?

6. Only 1 taskbar button when i open 2 excel documents

7. Displaying Multiple Excel Buttons on Windows Taskbar.

8. Grouping Files In Taskbar

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 45 guest