Address toolbar will show only one file

I

Ian Grega

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

Gord Dibben

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
 
I

Ian Grega

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
 
G

Gord Dibben

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/[email protected]


Gord Dibben Excel MVP
 
I

Ian Grega

Gord

Thanks for your help

Regards
Ian

Gord Dibben said:
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/[email protected]


Gord Dibben Excel MVP
Click to expand...
 
Top