## Taskbar group buttons unchecked and Excel

MS EXCEL

### Next

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

```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

```In xl2k (and higher), you can use:

--

Dave Peterson
```

### Re: Taskbar group buttons unchecked and Excel

```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
suggestions?

```

### Re: Taskbar group buttons unchecked and Excel

```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
xl2002.

What version of excel are you using?

--

Dave Peterson
```

### Re: Taskbar group buttons unchecked and Excel

```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

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

But I'm confused.

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

rightclick on Windows start button|properties|taskbar tab

(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
```

```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.

```

```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.

```

```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

Thanks

--
Todd Forbes
Northwest School Division
```

```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?
```

### Who is online

Users browsing this forum: No registered users and 45 guest