Disabling the Excel Compatibility Checker

Due to several comments about how much people hate this thing, I’ve pulled together a very rough, very simple add-in.  It’s goal is to disable the Compatibility Checker as much as possible.

I’m being quite up front that this was a VERY quick job, not well tested, and it can certainly be improved.  But it’s a start.  :)

It will disable the Compatibility Checker on all files that have already been saved at least once in Excel 97-2003 format.  New files are a little more problematic, though, as they seem to kick off the check even if you tell it not too.

You can find the add-in on my main site.

Oh.. and comments/improvements are welcome.  Please post them here.  :)

Some welcome relief

We had a new staff member start at Fairwinds today.  After going through a few interviews, we finally found one who we felt would fit perfectly with our team, who demonstrated an appropriate level of experience.  The road has been anything but smooth.

Back in May we had hired one of those dream emloyees.  You could throw things to her, and she’d just run with them.  In addition, and almost as important, she clicked with all of our team members.  It was awesome.  About 1 1/2 months in, though, she had some personal issues surface at home, and ended up moving across the country to be closer to her family.  Despite my best efforts, and that of my team, we simply couldn’t offer her anything to keep her at Fairwinds.  I don’t know if there is anything more frustrating than being powerless while you lose someone really good.  Our entire team was very sad to see her go.

We advertised for a suitable replacement twice, with no resumes coming in that made the cut.  (Again, I want the RIGHT person.)  At that point, I decided to scale the position back a bit, and promote one of my existing staff into it.  This left the issue of trying to fill her position.  Another two rounds of ads, a few interviews, and we finally have someone!

This is huge to me, as it means that I have someone on staff to train our new staff member.  It also means that, at long last, I can start passing off some of my accounting work, as well as start training my promoted assistant in the systems field.

Oh… and for the record, we DID interview this person.  We ended up choosing someone else, as we felt that they’d be a better team fit.

RibbonX available in Kindle edition

J-Walk posted that his Excel VBA Programming for Dummies has been Kindled.  I was a little surprised to find out that RibbonX – Customizing the Office 2007 Ribbon has as well!

I’ll be completely honest here… I have a pretty limited idea of what this even is.  From what I gather, it sounds like a palm pilot style book reader.  I can’t really see being interested in that myself, but there you go.  So if you’ve been waiting for it, now it’s here.  :)

When Applying for a job…

Some of you may recall I wrote up a post on things to check before you send your resume out for jobs.  Sadly, based on yet another job posting we’ve had here, I have to add this point:

Make sure you spell your own name correctly.  Or, if you are going to misspell it, don’t include it written one way in your email address and resume, and another in your cover letter.

I seriously wish I was joking about this, but there you have it…

File Sharing Technologies

Over the past while, I’ve been trying to solve a business need with some file sharing technologies.  There’s some neat things out there for this purpose.  The irony of the ones I’ve used, however, is that they are 3 distinct products, all made by Microsoft, and each of which treats things slightly differently.

Before I get into the software, here’s the issue I’ve been facing:

In addition to being the Controller at Fairwinds, I’m also the only on-site IT guy.  It’s therefore up to me to make sure that I’ve got all the information, when needed, where needed, in order to restore the systems should they go down for any reason.  And while I may call in outsourced techs to do the dirty work in restoring things, it remains up to me to be able to provide them with the information that they need.

I have a few really important documents that I basically need to be able to get to.  While I have remote access to my system, the issue is that it’s when the systems are down that I need the docs most, and I can’t get to them.  So basically, this meant that I need to create my Critical Info Document, save it (password protected) on my laptop, and save it to the server.  When I go on vacation, my boss needs a copy, and it then becomes important to make sure his is up to date, just in case he’s ever contacted because I’m unavailable.  I also want to share a copy with my outside support consultants so that they can deal with issues without me, should they need to.  (They are trustworthy and professional.)
So now I have several copies of the document that I need to maintain.  Maybe it wouldn’t be a big deal if the document wasn’t as fluid as it is.  But that’s neither here nor there as the reality is that it gets updated at least once a week, and sometimes once a day.  Saving and emailng copies of this document is not desirable from either a managment or security point of view.
So, enter the file sharing technologies.  Here’s the ones I looked at:

Groove

Groove has a bunch of uses including sharing calendars, sketchpads, and documents.   You can also set up full File Sharing folders to sync up between PC’s.  I looked at this very quickly, as it costs to install Groove on each PC.  In addition, because Groove is a big program, it feels a bit “heavy” if that’s all you want to do.  Of course, to access your files, you need to log on to a computer with your Groove account installed.  I’m also not convinced that you’ll get updates unless at least one user is online that you can sync to.  I’ve been told otherwise, but haven’t tested that for myself to date.

Don’t get me wrong, Groove is a great program, but I wouldn’t buy it if all you want to do is share files.

Windows Live FolderShare

FolderShare is a Windows Live Beta technology.  Pretty neat stuff, as you can create libraries to share between PC’s, libraries to share with other users, and even use the internet to access the files on your PC from a remote site (if it is on.)  What is cool here is that, when sharing a folder, you can invite others to it, and give them a variety of rights from read only to full editing.  It seems pretty light-weight and works fairly well from what I’ve seen.

The drawback here is that, if you are at a remote site without your PC, and it doesn’t happen to be on at home or in your office, you can’t access your files.  Maybe not a big deal to you, but if I need access to my Critical Info Document and all I have access to is an internet cafe…

Windows Live Mesh

This one is actually pretty cool, classified as a “Tech Preview”, which I believe is before even Beta.  It’s got all the benefits of FolderShare, and adds a couple more components.

Mesh has 5GB of storage “in the cloud”.  (Read as on Microsoft’s servers.)  So basically, when you connect to the internet, your selected folders sync up to the storage in the cloud, then down to your other PC’s.  This means that you can access your files over the internet, even if none of your PC’s are on.

And if one of your PC’s does happen to be on, throught the net you can remote control it, just like you would using a program like LogMeIn.

Mesh also displays a nice little message that synching with a mobile phone is “coming soon”.  That will be a pretty cool feature to add.

Some of the drawbacks with Mesh, at this point:

  • When inviting others to share a folder, you have to give them “Owner” rights.  That kind of sucks, as it would be nice to be able to decide who should have Read Only rights.
  • It’s a little bit awkward to set up synching folders, IMO.  Could be a bit cleaner.  Once you get used to it, it’s okay, but it’s not really intuitive.
  • “Non-US” customers are not eligible to sign up for an account, and they validate your email address to make sure it ends in .com ;)

A Security Perspective…

One of the things that I found ironic about these technologies is that you can’t share network drives.  I’m guessing that this is probably designed around security concerns, as we wouldn’t want all of our users sharing critical work files, would we?

Instead, we now push our users to save into non-network folders, which usually aren’t backed up, and push the storage to personal computers outside the company control.

Things I’d Like To See

Now, thinking about my critical information document that I share with consultants, it would be awesome if these technologies could be set up to do the following:

  • Prevent users (depending on permissions) from copying out of a folder that they have been given access to.  (I wouldn’t want them sharing with all their friends.)
  • Allow for a way for the owner to revoke files from an invited user.  (If I were ever to discontinue using these consultants, how can I assure that they lose access to my info?)