Where is that &$#@ command in Office 2007?!

 

Sounds familiar? This is the No. 1 complain for first time user of Office 2007 because of the new Ribbon user interface, quite a number of commands have been repositioned. I keep on telling people that after a couple of weeks they will get used to the new UI and actually be happy with it. Honestly at least I do (whether or not I working with Microsoft)

So for the rest of us, Office Labs launched a new Office add in called Search Commands. It helps you find commands, options, wizards, and galleries in Microsoft Office 2007 Word, Excel and PowerPoint. Just type what you’re looking for in your own words and click the command you need. Search Commands also includes Guided Help, which acts as a tour guide for specific tasks. (pic above)

Go here for more details.

Identify Duplicate Values in an Excel Table

In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.

1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells

Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete.

Error when installing VS2008 SP1 Beta on Windows 2008 VPC

I got the below error msg from the log

Exe (C:\Users\ADMINI~1\AppData\Local\Temp\Microsoft Visual Studio 2008 SP1 (Beta)\dotnetfx35setup.exe) failed with 0x80070643 – Fatal error during installation. :
[5/14/2008, 13:32:27] (IronSpigot::ExeInstallerBase:: PerformAction) PerformOperation on exe returned exit code 1603 (translates to HRESULT = 0x80070643)
[5/14/2008, 13:32:27] Action complete
[5/14/2008, 13:32:27] (IronSpigot::LogUtils::LogFinalResult) Final Result: Installation failed with error code: (0x80070643), Fatal error during installation.

I am doing this in a VPC environment with the below software installed

• Windows Server 2008 Standard RTM
• Visual Studio 2008
• Office 2007 w/SP1
• Windows SharePoint Services w/SP1
• SQL Server 2008 Feb 08 CTP

Already posted my issue in the forum, will update the blog if I manage to find a solution