On Aug 12, 9:40*am, Bread wrote:
I dont know how i lost the ability, but i used to be able to open excel files
as separate windows. *Now, it seems everytime i open a new file, it opens
within Excel and i have to go through "Windows" in the toolbar to switch
between files. *Is there any way to restore the aboilty to open each ecel
file as a separate window? *

Not quite sure what the question is here.

If it's about grouping in the task bar you just need to edit the
windows taskbar settings?

If you mean you want to open each spreadsheet in a new instance of
excel, I believe it's something
to do with the file association. If your running vista tweaking of
file associations has been limited
somewhat.

I actually have the opposite problem - my excel 2007 opening every
workbook in a new instance stops my
global macros from working on these sheets, as personal.xls only opens
in the first instance and you
get extra dialogue boxes every time you open a file. I have yet to
find the answer!

Mike