Comments for PTS Blog

Comment on Installing an Add-In in Excel 2007 by Jon Peltier

Jon Peltier — Mon, 13 Jul 2009 01:24:30 +0000

Mak -

Well, there’s that sad little excuse for a toolbar, called the QAT, stashed up in the title bar. You could try adding your command there. Otherwise you could hack together some XML, which isn’t too hard, but there’s a bit of a learning curve.

Comment on Installing an Add-In in Excel 2007 by Mak

Mak — Mon, 13 Jul 2009 00:55:46 +0000

G’day John!

Do you have any idea how to add more commands to the Excel 2007 Ribbon. I wanna add a hyperlink to a file.

Cheers
Mak

Comment on New Computer by Jon Peltier

Jon Peltier — Sat, 11 Jul 2009 20:55:04 +0000

Doug -

Thanks for checking in with your experiences. I’m planning to do the Windows 7 64-bit option, and you have helped show me it’s a viable approach.

Comment on New Computer by Doug Glancy

Doug Glancy — Sat, 11 Jul 2009 20:50:44 +0000

Two comments on those thinking of using Server 2008 as their laptop operating system:
1. I tried to use Hyper-V the virtual pc program available under Server 2008, but it didn’t support the 1440*900 resolution of my laptop, so I couldn’t ever maximize the virtual machine. Also, installing Hyper-V disables the ability to put the laptop on standby/sleep.
2. My antivirus program, NOD32, wouldn’t install unless I purchased the server edition, which is only available in 5-license packs. There is a similar issue with other antivirus programs.
Now I’m running Windows 7 64-bit and the 64-bit version of Nod32, as well as the somewhat updated Windows Virtual PC program. I think VPC has somewhat improved networking settings, and it now supports USB drives.

Comment on Pie Chart Rounding in Excel by Jon Peltier

Jon Peltier — Fri, 10 Jul 2009 19:34:04 +0000

Ben - That seems to have solved the problem. Now we just have to teach all those middle managers how to apply an Excel number format.

Comment on Pie Chart Rounding in Excel by Ben Miller

Ben Miller — Fri, 10 Jul 2009 19:28:42 +0000

Try setting the label formatting to #%

Comment on New Computer by Colin Banfield

Colin Banfield — Fri, 10 Jul 2009 13:22:04 +0000

“I’m thinking about using an on-line service. I wanted to get a few thoughts and opinions from the readers.”

Mike, because all of the major ISPs in my area charge for usage, online backup isn’t an option for me - but even if it was, it would be impractical to ever do a full backup of a 1.5TB drive at Internet speeds. I’m leaning towards a NAS option. A DLink DNS-323 two-drive NAS box with Gigabit Ethernet isn’t expensive. Stuff two 1.5TB drives (also not that expensive) in a mirror configuration and you should be good to go. If you also want to plan for potential fire damage, then you’ll have to find a fireproof housing designed for computer equipment, or go with an option such as provided by ioSafe.

Comment on New Computer by Dennis Wallentin

Dennis Wallentin — Fri, 10 Jul 2009 12:44:15 +0000

Jon,
While reading throw the comments and that You backup several computer it strikes me that You should also use NAS unit for the backups.

I’ve been using a NAS (2 x 500 GB) for all backups on my local network together with Windows Scheduler.

Personally I have difficulties to trust a third-party for my backups, especially for XL-Dennis.

Kind regards,
Dennis

Comment on New Computer by Mozy Fan

Mozy Fan — Fri, 10 Jul 2009 04:59:52 +0000

At least your data is safe with Mozy ;).

Comment on New Computer by Tim Wilson

Tim Wilson — Thu, 09 Jul 2009 22:48:57 +0000

Inspired by the “tried propping it up on blocks” comment early in your post: If the new fan doesn’t do the trick, and you determine the laptop really has reached the end of its useful live, I think it’d be nifty for you to take it out to your front yard, “prop it up on blocks” (what you were already using…or go all out and get a couple cinder blocks), let weeds grow up around it, and see how long it takes for the neighbors to complain…