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

ToolsOptionsView. Check "Windows in Taskbar".


Gord Dibben Excel MVP

On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
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".........

ToolsOptionsView. Check "Windows in Taskbar".


Gord Dibben Excel MVP

On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
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
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".........

ToolsOptionsView. Check "Windows in Taskbar".


Gord Dibben Excel MVP

On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
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
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".........

ToolsOptionsView. Check "Windows in Taskbar".


Gord Dibben Excel MVP

On Thu, 21 Apr 2005 15:56:03 -0700, Ian Grega <Ian
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.