Category Archives: Tech

Excel 2007 Wrangling: Single Window Fail

This also applies to Excel 2010.

Out of the box, Excel 2007 opens multiple spreadsheets in one window. In past versions, this was always resolved by going to Tools -> Options -> General, and checking the box labeled “Windows in Taskbar.” Excel 2007 also has this checkbox (Office button -> Excel Options -> Advanced -> Display, check ”Show all windows in the Taskbar”), but the windows in the taskbar are pretty much a mirage, because your spreadsheets are definitely not in different windows. This is a pretty big pain if you use dual monitors, or like to cascade your windows without maximizing Excel. Sorry Microsoft, sometimes we want email, media players, a browser, or any number of other applications in the background rather than a dull grey screen. It would also be nice if you experience a document crash and it doesn’t take the rest of your documents with it!

One workaround: Open a new instance of Excel every time you want to open a document. This is not the best solution because opening documents from email or a document management system will still open the documents in your first instance of Excel.

One possible solution: Office button -> Excel Options -> Advanced -> General, check the box labeled “Ignore other applications that use Dynamic Data Exchange (DDE).” This works, but if you ever need to open documents from an email application or a document management system, well, you’re SOL.

If you’re still using XP, you’re in luck. There is a way to fix this without editing the registry.

  • Open Windows Explorer, go to Tools, click Folder Options
  • Go to File Types and find your Excel file extensions, (most frequently used extensions are .xls, .xlsx, .xlsm)
  • You will have to do this for each extension. Click on the extension, click Advanced, click Open, then click Edit.
  • Where it says “Application used to perform action,” add /e “%1″ to the end of the file path
  • Uncheck “Use DDE.”
  • Click OK, click OK, find your next extension, and repeat the process.

If you’re using Vista or Win7, unfortunately, you have to edit the registry. If you’ve never edited your registry before, this is a task best left to the experts. If you rename, delete, or modify the wrong key, you can seriously damage your Windows installation. Back your registry up before you change ANYTHING. The registry edits necessary to fix this Excel “functionality” are listed below. These are for .xls, .xlsx, and .xlsm.

  • HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command:
    Double Click on (Default), add “%1″ to the end of the string so it displays “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1″

    • Right Click on Command – choose “rename” and add something to the name  – for example 2 (command2)
  • HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:
    Right Click on the folder ddeexec and choose “rename” and add something to the name  – for example 2 (ddeexec2)
  • HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command:
    Double Click on (Default), add “%1″ to the end of the string so it displays “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1″

    • Right Click on Command – choose “rename” and add something to the name  – for example 2 (command2).
  • HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec:
    Right Click on the folder ddeexec and choose “rename” and add something to the name  – for example 2 (ddeexec2)
  • HKEY_CLASSES_ROOT/Excel.sheetMacroEnabled.12/shell/Open/command:
    Double Click on (Default), add “%1″ to the end of the string so it displays “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1″

    • Right Click on Command – choose “rename” and add something to the name  – for example 2 (command2).
  • HKEY_CLASSES_ROOT/Excel.sheetMacroEnabled.12/shell/Open/ddeexec:
    Right Click on the folder ddeexec and choose “rename” and add something to the name  – for example 2 (ddeexec2)

Source: http://social.answers.microsoft.com/Forums/en-US/w7files/thread/f7588d9a-3c41-466f-8f01-3b6ab9661ae3

Disclaimer: I have done this on my machine and it works. If this is your work PC I would advise bringing it up to your IT staff members before you carry out these registry edits. I am not responsible for you screwing up any of your PCs in any fashion! :)

Fail

Ugh, fail, and I didn’t even know it. Sorry about the damn video in my last post. I am perpetually muted and I tested the video in IE, and it didn’t auto-play. But, apparently, it still autoplays in Firefox. So if any of you suffered I’M SORRY. I removed the embedded media and put a link there because I don’t feel like fixing it right now.

T-Mobile Update

Just as an update…  We are still unable to make outgoing phone calls.  And T-Mobile continues to be inaccessible and completely inattentive.  Thanks guys!

We DID end up changing our Comcast modem — instead of having the combo internet/phone modem, we now have a straight cable modem without phone capability.   At this point, it’s likely the only thing keeping us from using our phone like normal people is Comcast, a la a couple of blocked ports.  Dominic at the @home customer (cough) support said that he would work with Comcast on the issue, but it has now been over a week and a half and we have not heard anything from him (or any of his team members for that matter).  I have left them voicemails, since you cannot actually reach a person when you call advanced technical care, but no one will return my call.

I would, you know, call Comcast myself, but I can’t make outgoing phone calls at home and I have no mobile reception while in the house.  Standing outside talking to Comcast would make testing rather difficult.  Considering the fact that I’ve spent hours on the phone with T-Mobile regarding the issue, I can only hope they will help me out a little here…

I’m probably hoping too hard.