Excel 2007 help. - Calgarypuck Forums - The Unofficial Calgary Flames Fan Community

Galakanokis · 03-22-2012, 01:48 PM

I have a small Excel 2007 problem that is driving me nuts. Basically I can no longer open multiple spreadsheets in separate windows, they just launch into the current window that is already open. It wasn't like this before, every time I clicked on a new spreadsheet it opened in its own window.

All I have done is add a second monitor and rebooted the PC. I have searched the web and found some "solutions" but it still doesn't work the way it use to. The main fix I found was to uncheck Ignore other applications that use DDE but all that does is open a blank spreadsheet.

Any Excel gurus out there that can help out?

BlackArcher101 · 03-22-2012, 01:56 PM

Hmmm, mine never worked that way. I've always had to open a separate blank excel window then click the file to open it as a second window.

Teh_Bandwagoner · 03-22-2012, 02:14 PM

Once Excel is open, you can't double click a file or open it within Excel to get a new window like Word. It will just open up in your existing Excel window. You have to re-open Excel through a shortcut or the exe file for it to pop up in an entirely different window. In other words, just open Excel again with an icon.

I'm actually not sure how you were able to do it before. As far as I knew it's like this from Excel 2003 right to 2010. I wouldn't mind some enlightenment here either!

Galakanokis · 03-22-2012, 02:56 PM

Aw man. I didn't think I was on drugs but perhaps I am. I have had least 6 spreadsheets open for weeks now and I positive I never did anything fancy with regards to opening multiple windows. Damn. Oh well.

Komskies · 03-22-2012, 03:15 PM

Ctrl + N?

Wormius · 03-22-2012, 03:51 PM

Were you using Windows 7? It took a bunch of tweaks to get it to work better (i.e. Windows XP) with the taskbar and everything.

Galakanokis · 03-22-2012, 07:28 PM

Quote:

Originally Posted by Wormius

Were you using Windows 7? It took a bunch of tweaks to get it to work better (i.e. Windows XP) with the taskbar and everything.

XP. I tried a few tweaks but nothing works great. What did you do?

rayne008 · 03-23-2012, 08:56 AM

Quote:

Originally Posted by Teh_Bandwagoner

Once Excel is open, you can't double click a file or open it within Excel to get a new window like Word. It will just open up in your existing Excel window. You have to re-open Excel through a shortcut or the exe file for it to pop up in an entirely different window. In other words, just open Excel again with an icon.

I'm actually not sure how you were able to do it before. As far as I knew it's like this from Excel 2003 right to 2010. I wouldn't mind some enlightenment here either!

This is what I do when I want to have both sheets open in different monitors...

Wormius · 03-23-2012, 04:38 PM

Quote:

Originally Posted by Galakanokis

XP. I tried a few tweaks but nothing works great. What did you do?

Sorry, I meant if you were using Windows 7 then by default everything opens up as a group, rather than in individual windows.

worth · 03-23-2012, 10:37 PM

You have to open two seperate instances of excel. You can not open through shortcuts.

Open excel by going through the start menu. Then go File > open and find your document.

Go back to the start menu and open excel again. Then go File > open and find your next document.

This should work. This is how I do it in XP. It took me 8 years to figure this out.

Flames89 · 03-26-2012, 08:23 AM

Use the one instance of excel, multiple panes, spread across your two windows, so that way you can copy and paste and link between your files.
A program called Ultramon is awesome for two screens.

Galakanokis · 03-26-2012, 10:25 AM

Thanks for the tips guys. I swear I never had to do any of this before, just double click and away I went.

Oh well, have some work arounds.

I will check out that Ultramon software as well.