I want to change the defaults so when I open multiple spreadsheets/workbooks
they open in one application of excel only - i.e. if I go to 'View -> Switch
window' all the workbooks are shown.

Currently when I open an Excel file it will open automatically in a new
instance of Excel. I know I can open mutiple files if I choose 'Office
Button -> Open' but if I double click an Excel file in windows explorer this
is when they open in a new application of Excel.

I know you can do this in previous versions of Excel but cant find this
option in Excel 2007.

Can anyone offer any advice please?

I would ask this in a Microsoft Excel newsgroup, as this question depends on
Excel and not Vista.

--
Richard G. Harper [MVP Shell/User] rgharper@xxxxxx
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/


"Saboo" <Saboo@xxxxxx> wrote in message
news:A6F95DF1-BC56-4B7B-8F66-51062041B3CE@xxxxxx

>I want to change the defaults so when I open multiple
>spreadsheets/workbooks
> they open in one application of excel only - i.e. if I go to 'View ->
> Switch
> window' all the workbooks are shown.
>
> Currently when I open an Excel file it will open automatically in a new
> instance of Excel. I know I can open mutiple files if I choose 'Office
> Button -> Open' but if I double click an Excel file in windows explorer
> this
> is when they open in a new application of Excel.
>
> I know you can do this in previous versions of Excel but cant find this
> option in Excel 2007.
>
> Can anyone offer any advice please?