| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open two spreadsheets in two windows?
I have figured out how to open two excel files in separate windows. However,
I realized that many functions had been disabled by this option. I have tried to reverse the process to go back to the original (defulat setting) but no success! Any help in this matter? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to open two spreadsheets in two windows?
If you open two sessions of Excel (clicking on the Excel icon twice), this
will disallow referencing the other sheet. Better to have one open in an instance, then open another using the File - Open menu. Once both are open go to Tools - Options - View tab - Windows in Taskbar. Now you should see two windows and be able to reference across workbooks. "Osama" wrote: I have figured out how to open two excel files in separate windows. However, I realized that many functions had been disabled by this option. I have tried to reverse the process to go back to the original (defulat setting) but no success! Any help in this matter? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to open two spreadsheets in two windows?
Check Tools -Options - General - Ignore Other Applications (it should be
unchecked). -- HTH... Jim Thomlinson "Osama" wrote: I have figured out how to open two excel files in separate windows. However, I realized that many functions had been disabled by this option. I have tried to reverse the process to go back to the original (defulat setting) but no success! Any help in this matter? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheets in separate windows | Excel Discussion (Misc queries) | |||
| XL 2007 - Multiple windows for spreadsheets (SDI) | Excel Discussion (Misc queries) | |||
| Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
| i try to open Excel spreadsheets, and they open in wordpad-- | Excel Discussion (Misc queries) | |||
| open multiple excel spreadsheets in separate windows by default | Setting up and Configuration of Excel | |||
Linear Mode
