Fix #NAME and #N/A errors in Excel for Mac

September 28th, 2007

After months of quietly defending the Mac against relentless condemnation for the way Excel 2004 mangles formulae and references in spreadsheets created on Windows systems, I discovered today a three-click solution for a whole swath of problems: the “Analysis ToolPak” Add-in for Excel.

The problems manifest as #NAME or #N/A appearing all across your delicate sheets and workbooks when you alter a cell containing a date used in a formula. I can find no reasonable explanation for this, but the plugin apparently makes Excel calculate things the same as it does in Windows. Why it doesn’t just do this already, I can only speculate angrily.

Installing the plugin to fix things is simple:

  1. In Excel, select “Add-ins…” from the “Tools” menu.
  2. Check the box next to “Analysis ToolPak”
  3. Click “OK”

The plugin installs automatically and takes effect immediately. Any open spreadsheets will be re-calculated, but I would recommend closing and re-opening any affected spreadsheets for the sake of consistency.

Here’s looking forward to Office 2008, the elimination of all compatibility issues between the platforms, and the subsequent series of blog posts about dealing with the remaining compatibility issues between the platforms.

Enable the Start menu in VMWare Fusion

August 10th, 2007

I find the recently-released VMWare Fusion 1.0 to be better, faster, and more Mac-like, feature-for-feature, than Parallels. By default, however, its Unity mode goes a bit too far in its seamless Mac integration by hiding the Start bar entirely, in the hope that you’ll use the admittedly more Mac-style “Applications” menu VMWare provides. Fortunately, revealing the Start bar, your Windows windows, and your system tray again is a simple tweak to the VMWare Tools config file.

To enable the Start menu and Taskbar in a VMWare guest:

  1. With Windows running, switch to Single Window or Full Screen mode
  2. Open C:\Documents and Settings\All Users\Application Data\VMWare\VMWare Tools\tools.conf in Notepad
  3. Add the following line at the end of the file:
    unity.showTaskbar = "true"
  4. Save and close tools.conf

The toolbar will be visible when you next enter Unity mode. Brilliant!

With this tweak, VMWare’s Unity mode is superior to Coherence mode in Parallels. The Windows windows in Unity do the right thing when you activate Exposé, for example. They also have nice shadows, like other Mac windows, and they are truly interleaved with Mac windows, not grouped together in a giant invisible window like in Parallels.

Overall, I also find VMWare to be faster than Parallels, not just in running Windows, but in launching, exiting, pausing and resuming the guest OS. It also seems to be less demanding of OS X resources than Parallels. Plus, the UI is much simpler and smoother, using real Aqua controls and adhering to Apple HIG.

I only wish VMWare would release for Mac the tools they have for Windows that can convert from Parallels VMs to VMWare VMs. Give ‘em time, I suppose.

And with his very next post, it was gone.

July 31st, 2007

Sadly, just weeks after the preceding tribute to my ever-rugged Jeep, a series of electrical mishaps brought my trusty pal to his ultimate demise.

But from the ashes of his spirit has arisen his most worthy successor:

My new Imperial stormtrooper.

It’s eager, plush, scrappy, and clever. Not a single function of the ship’s operation isn’t under its control. It puts itself to the fullest possible use, which is all I think that any conscious entity can ever hope to do.

Time with my old Jeep was well spent. I’m looking forward now to time spent in my new one.

Seven years and 200,000 miles

April 11th, 2007

My trusty, rugged Jeep drove its two hundred thousandth mile today. I took the keys to it almost exactly seven years ago.

My parents and I bought this 1999 Cherokee Sport while they were visiting for Trinity University’s “Parents’ Weekend” in 2000, my junior year. I had long been in search for a worthy successor to the 1989 Toyota Corolla GT-S which carried me through all the twists and turns of high school and most of college. My next vehicle needed to be of equally uncompromising capability, accommodation, and readiness. Also among the highest priorities was that the new ride should also be black.

After months of classifieds, dealers, and frustrating online research in an era before cars were really available on the web, I was rapidly resigning myself to something like a Ford Ranger or some midsize practical-but-sporty sedan.

I’d be a lesser man writing today were it not for a fateful encounter at the Red McCombs dealership on north 281 in San Antonio that weekend. Mom had picked up a lead in the paper on a Jeep Cherokee with low miles and premium options. Unlike the teal and pink abominations I had already dismissed, this one met my color specifications.

As I slid into the driver’s seat, I knew immediately. The clear lines of sight all around, the modest but forthcoming displays, the tinted windows, even the factory-option Infinity sound system… the fresh interior and crisp controls were natural extensions of my awareness.

The test drive was quick, precise, capable, agile, energetic, and “rugged” — a word I would often utter involuntarily as I later rumbled over obstacles rural and urban (to the delight of one particular companion).

It has since carried me and many close to me to most major cities in Texas, New Mexico, Utah, Colorado, Kansas, Oklahoma, and Louisiana, through countless small towns along the way. It has been below sea level and above 14,000 feet. It has been on three islands. I drove it across Galveston during the peak of Hurricane Claudette.

Only four people have ever driven it besides me, for a combined total of less than 300 miles.

It has been towed three times, burglarized twice, and crashed once. It has never left me stranded. I’ve been pulled over in it several times, cited only three times, and dismissed every time. I have slept in it, but I’ve never made love in it; it has always carried me to beautiful destinations more suitable.

I have never been without it for more than nine days at a time. Its key has been on my person nearly every day of my life since it was placed in my hand. Only my glasses have been on my person longer.

A day will come when this trusty Jeep can drive no more. It could be 5,000 miles from now, 50,000 miles from now, or another 200,000. I hope it will be with me for many more adventures, however, because few things have been as faithful a part of my life as this Jeep, and there will truly never be a replacement for the things it has enabled me to do and become.

To end with an appropriate cliché, “Here’s to the long road ahead.”