Address toolbar will show only one file

With multiple excel files open the address toolbar will only show one of
these. It used to show all open files until I downloaded an Office update
recommended by Microsoft after I sent off an error report for an Excel bug.

Apologies for first message omitted - "appreciate if anyone could help"

"Ian Grega" wrote:

> With multiple excel files open the address toolbar will only show one of
> these. It used to show all open files until I downloaded an Office update
> recommended by Microsoft after I sent off an error report for an Excel bug.

Ian

Assuming you mean "taskbar" and not "toolbar".........

Tools>Options>View. Check "Windows in Taskbar".


Gord Dibben Excel MVP

On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
Grega@discussions.microsoft.com> wrote:

>With multiple excel files open the address toolbar will only show one of
>these. It used to show all open files until I downloaded an Office update
>recommended by Microsoft after I sent off an error report for an Excel bug.

Gord,

Thanks for your reply, this works after I have opened all files but how do I
get Excel to do this without having to go in and check "Windows in Taskbar"
every time.

Ian


"Gord Dibben" wrote:

> Ian
>
> Assuming you mean "taskbar" and not "toolbar".........
>
> Tools>Options>View. Check "Windows in Taskbar".
>
>
> Gord Dibben Excel MVP
>
> On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
> Grega@discussions.microsoft.com> wrote:
>
> >With multiple excel files open the address toolbar will only show one of
> >these. It used to show all open files until I downloaded an Office update
> >recommended by Microsoft after I sent off an error report for an Excel bug.
>
>

Ian

The setting should stick unless you are running Office 2000........

This is a bug with shared workbooks in Office 2000 and it seems there never
was a fix for it.

Excel 2002 has corrected the bug.


A suggested workaround by Dave Peterson.

Maybe you could use a workbook that checks this setting each time it could get
changed:

http://groups.google.co.uk/groups?th...F659%40msn.com


Gord Dibben Excel MVP

On Sun, 24 Apr 2005 21:06:04 -0700, Ian Grega
<IanGrega@discussions.microsoft.com> wrote:

>Gord,
>
>Thanks for your reply, this works after I have opened all files but how do I
>get Excel to do this without having to go in and check "Windows in Taskbar"
>every time.
>
>Ian
>
>
>"Gord Dibben" wrote:
>
>> Ian
>>
>> Assuming you mean "taskbar" and not "toolbar".........
>>
>> Tools>Options>View. Check "Windows in Taskbar".
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
>> Grega@discussions.microsoft.com> wrote:
>>
>> >With multiple excel files open the address toolbar will only show one of
>> >these. It used to show all open files until I downloaded an Office update
>> >recommended by Microsoft after I sent off an error report for an Excel bug.
>>
>>

Gord

Thanks for your help

Regards
Ian

"Gord Dibben" wrote:

> Ian
>
> The setting should stick unless you are running Office 2000........
>
> This is a bug with shared workbooks in Office 2000 and it seems there never
> was a fix for it.
>
> Excel 2002 has corrected the bug.
>
>
> A suggested workaround by Dave Peterson.
>
> Maybe you could use a workbook that checks this setting each time it could get
> changed:
>
> http://groups.google.co.uk/groups?th...F659%40msn.com
>
>
> Gord Dibben Excel MVP
>
> On Sun, 24 Apr 2005 21:06:04 -0700, Ian Grega
> <IanGrega@discussions.microsoft.com> wrote:
>
> >Gord,
> >
> >Thanks for your reply, this works after I have opened all files but how do I
> >get Excel to do this without having to go in and check "Windows in Taskbar"
> >every time.
> >
> >Ian
> >
> >
> >"Gord Dibben" wrote:
> >
> >> Ian
> >>
> >> Assuming you mean "taskbar" and not "toolbar".........
> >>
> >> Tools>Options>View. Check "Windows in Taskbar".
> >>
> >>
> >> Gord Dibben Excel MVP
> >>
> >> On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
> >> Grega@discussions.microsoft.com> wrote:
> >>
> >> >With multiple excel files open the address toolbar will only show one of
> >> >these. It used to show all open files until I downloaded an Office update
> >> >recommended by Microsoft after I sent off an error report for an Excel bug.
> >>
> >>
>
>