Want to copy that? Go to the paste menu

Ok, we all had a good laugh when Windows 95 came out and you had to "start to stop" because to shut down the computer you clicked the Start button. Personally, I never had much of a gripe with that. But now Microsoft really has gone too far in Office 2007. Say you're in Excel and you want to copy a range as a picture. Guess where you go? C'mon, just guess.

Yep, the paste menu.

Really.

Here's the full scoop, nicely written up by PC Magazine.

Launching Salesforce ID links from Excel

I've built a lot of Excel pivottables that work of a local copy of our Salesforce data (thanks forceAmp!) and one feature that I incorporated into them that's very popular is the ability to click on a cell that has a Salesforce ID (15 or 18 digit versions, either will work) and then run a very simple macro either from a button on the toolbar or from a keyboard shortcut that will take the user to that record in Salesforce. It's an incredibly simple macro, too. Here it is:

ActiveWorkbook.FollowHyperlink ("https://na3.salesforce.com/" + ActiveCell.Text)

Note that na3 will need to be replaced with your Salesforce server code. If anyone needs help in creating this macro and adding it to the toolbar and as a shortcut, let me know and I'll add those instructions. If anyone comes up with improvements to this thing, that would be cool, too. It doesn't gracefully handle it when a user doesn't have an ID selected, for example.