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.
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
- Select the list in which you want to identify duplicates.
- Click the Home tab on the Ribbon.
- 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.
Categories: Uncategorized Tags: Excel
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 0×80070643 - Fatal error during installation. :
[5/14/2008, 13:32:27] (IronSpigot::ExeInstallerBase:: PerformAction) PerformOperation on exe returned exit code 1603 (translates to HRESULT = 0×80070643)
[5/14/2008, 13:32:27] Action complete
[5/14/2008, 13:32:27] (IronSpigot::LogUtils::LogFinalResult) Final Result: Installation failed with error code: (0×80070643), 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
