Vista - Multi Spreadsheets in Excel 07

OK I give up!
I have been running Office 2007 for a few months now and I am just now in need of opening TWO Excel spreadsheets at once.

I can open one in the first tab then select a new tab for another populated spreadsheet and import.
As I remember from 2003 this should populate two tabs with two spreadsheets!

However when I follow this process the first sheet disappears altogether superceded by the second with no trace of the first remaining?
When I close the second instance of Excel I now have my first spreadsheet visible.

This would be funny if I didn't require comparison of sheet1 with sheet2 preferrably in a side by side manner. or import and sharing of data in multiple tabs.

What is up with this??? Please show me my error.

See if you can find some info here -

Microsoft Excel 2007 Tutorial—Free & Online

Let us know how you go.

Have you tried cut and paste.

Yes I did. and Doh! it works fine, just seems I need to do each import page indivddually. I Thought 2003 could import the file but this solution should be good for now.

Thanks all for all of the help.
Now on to my no start from mouse issue, but thats another day.