I'm a big time multitasker, sometimes needing to see up to 4 excel files side-by-side spread across my two monitors. By default in Excel 2007, all files are combined under one window, which makes spreading out the files impossible. After searching around Google a few months ago I finally found a way to separate these files, and that is to go to Excel Options, Advanced, General tab, and check the box that says Ignore other programs...DDE.
The problem is, with that box checked, I can't double click a file to open it; I have to open excel then manually browse for the file I need, which is usually 8 or 9 subfolders down. Doing that 4 times to open up everything I need is very tedious, it would be much easier to just find the folder once and double click all files I need opened.
So I guess my question is, is there anyway to have the best of both worlds?
The problem is, with that box checked, I can't double click a file to open it; I have to open excel then manually browse for the file I need, which is usually 8 or 9 subfolders down. Doing that 4 times to open up everything I need is very tedious, it would be much easier to just find the folder once and double click all files I need opened.
So I guess my question is, is there anyway to have the best of both worlds?
Facebook
Twitter