You can, it's just a shame that instead of doing the amazing stuff with it, most people I know try to use it to store data that should be in a database and wonder why it's not behaving the way they think it should or it's got hundreds of lines of code to do what you can do in SQL in two...
EXCEL!!! I HATE IT!
- Thread starter something_totally_different
- Start date
You can, it's just a shame that instead of doing the amazing stuff with it, most people I know try to use it to store data that should be in a database and wonder why it's not behaving the way they think it should or it's got hundreds of lines of code to do what you can do in SQL in two...
Not sure if you've solved this by now, but I do it all the time. Just open the first document by double clicking on the xls file, then open excel.exe and file -> open the second xls file.
Why would anyone who already owns Office 2007 want OpenOffice?Rich43 said:
Man of Honour
- Joined
- 17 Nov 2003
- Posts
- 36,747
- Location
- Southampton, UK
Soldato
- Joined
- 25 Nov 2007
- Posts
- 5,581
- Location
- London
indeed, wouldnt go too far but yea i got Office Enterprise Edition, and ive not installed half the stuff, Excel owns
Man of Honour
- Joined
- 17 Nov 2003
- Posts
- 36,747
- Location
- Southampton, UK
That's a shame, there's not one bad product in the suite really. The closest is Publisher.
Burnsy
dont know if the OP was still looking for this, but it allows you to have more than one excel 2007 window open at a time.....
1. Open my computer
2. Click on Tools, then Folder Options
3. Select the File Types tab
4. scroll down to the XLS extension
5. select advanced
6. Select open
7. Select Edit…
8. in the line that says "Application used to perform action:" ,
go to the end of the line and add "%1"
(that would be %1 within double quotes) so for example it may read something like
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
9. uncheck Use DDE
10. Do not make any other changes
11. Click ok and click OK again
(note if you go back into advanced and back into the open action, you will notice DDE is checked again, however the DDE message is blank; this is fine.)
12. Now scroll down to XLSX
13. repeat steps 5 through 11 above
14. Click on Close
15. Now, when you click on Microsoft Excel 2007 spreadsheets, they will open separate windows for each Microsoft Excel 2007 spreadsheet that is launched.
note: Microsoft Excel 2007 spreadsheet windows will open on top of eachother, so you will have to drag the windows in order to see them.
1. Open my computer
2. Click on Tools, then Folder Options
3. Select the File Types tab
4. scroll down to the XLS extension
5. select advanced
6. Select open
7. Select Edit…
8. in the line that says "Application used to perform action:" ,
go to the end of the line and add "%1"
(that would be %1 within double quotes) so for example it may read something like
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
9. uncheck Use DDE
10. Do not make any other changes
11. Click ok and click OK again
(note if you go back into advanced and back into the open action, you will notice DDE is checked again, however the DDE message is blank; this is fine.)
12. Now scroll down to XLSX
13. repeat steps 5 through 11 above
14. Click on Close
15. Now, when you click on Microsoft Excel 2007 spreadsheets, they will open separate windows for each Microsoft Excel 2007 spreadsheet that is launched.
note: Microsoft Excel 2007 spreadsheet windows will open on top of eachother, so you will have to drag the windows in order to see them.
thanks