• 
  

• Recently Updated

  • Kari|Doyle
  • dsu | Mike
  • sonja | johnson
  • andy's place...
  • Shar

• Blogroll

  • Andy Ogan
  • Holli Rausch
  • Jeff Gabhart
  • Jeff Vonasek
  • lawlRedneck
  • Miles Rausch
  • Seth Larson
  • Sonja Johnson
  • ZombieFoodDan

• dootdoot

  • dootdoot
  • dootdoot | Chat
  • dootdoot | Forums
  • dootdoot | Photos

• Links

  • Dakota State University
  • Media Portal / TV Server
  • Windows Home Server

I end up using Excel a lot at work. We have all sorts of branded forms, sizing sheets, etc. that prove to be very useful. Unfortunately, I’m often the one who has to design them as well.

One thing I’ve found particularly annoying is trying to do work in two separate spreadsheets. In Excel 2007, the default functionality is to open any and all spreadsheets in a single Excel window. If you’re like me and have dual monitors and are trying to design a new spreadsheet, copy information from one to another, or even just compare information in two separate document — this can be a HUGE chore.

Fortunately, there is a way to disable this behavior and have Excel open each spreadsheet in a new window.

1. Open Excel 2007.
2. Left-click the Office 2007 button in the upper left.
3. Select “Excel Options” in the lower right.
4. Select “Advanced” in the left pain.
5. Scroll down to the “General” section.
6. Check “Ignore other applications that use Dynamic Data Exchange (DDE).”
7. Click OK.
8. Done.

It’s quick and easy, and now you can have two separate Excel spreadsheets each open on a separate monitor.

Now if only I could figure out how to do this for PowerPoint…

The 2010 Winter Olympics in Vancouver came to an official close this evening. It was reported that over 55,000 people attended the event held at BC Place, with over three billion watching via television or online.

The Closing Ceremony was interesting. As an interesting fact, the 2010 Olympics Opening and Closing were the first in history to be held in doors. As such, it was a $40 million dollar production with singing, dancing, short speeches from celebrities, and, of course, the passing of the Olympics to Sochi, Russia for the 2014 Olympics.

Prior to the Closing Ceremony, we watched the final USA vs Canada hockey game, which was a great game. While it was disappointing that Team USA didn’t win like they did when they stomped Canada last week, it was exciting all the way until the end, with a sudden death over time round.

There was some additional coverage of the victory ceremonies as well. I really liked this recap of the Olympics, showing highlights and medalists for the various events (especially since I didn’t really bother to watch any of them other than Curling and Hockey — but really, were any of them other than those two worth watching? Nah.).

I did a quick check on the stats, and apparently the United States came home with the most Medals, 37. However, Canada came home with the most gold’s at 14 (USA - 9).

All-in-all, the 2010 Olympics were great. The Winter Olympics have always been my favourite (mostly because of Curling and Hockey), so it’s always sad to see them end.

Uh-oh, it’s about that time. My pre-release copy of Windows 7 is about to expire (apparently in 2 days).

Oddly enough I have had a legal copy ready for awhile, but haven’t bothered to reinstall since everything was “working” fine. Now I’m wishing I would have done it awhile back to avoid having to go backup all my crap, reinstall, reinstall, reinstall, reinstall and copy back over.

On the plus side, the Windows Home Server is proving to be quite useful for a nice place to store things. And I’ve gotten a lot better about storing long-term documents there, so I have a lot less to copy back over after the reinstall.

« newer — older »