Office 2010 Service Pack 1 Installation Error

Wanting to update Office 2010 on two computers, I opted to downloaded the Service Pack package (http://support.microsoft.com/kb/2460049) instead of using Windows Update. The installation of SP1 went fine on the one computer, but the other gave an ugly error: “There are no products affected by this package installed on this system.

       image

Googling revealed many other users with the same error message, and the only sure solution offered was uninstalling and reinstalling Office. This was not an option for me. And then came the solution… on checking the version numbers of Outlook, Word and Excel on the computer where the update failed, I realised that SP1 was already installed. Windows Update took care of installing SP1 without me realising it! Embarrassed smile

If you are reading this blog post, you probably came across the same error message, and perhaps your Office 2010 has Service Pack 1 installed automatically as well. Here is how to check if SP1 has been installed:

  • On the File menu (in any Office application), click Help.
  • Note the version number.

If the version number is equal or bigger than 14.0.6023.1000, then you have SP1 installed. (My version is 14.0.6112.5000). If so, then problem solved!

If the version number is smaller than 14.0.6023.1000 (e.g. the original Office 2010 version is 14.0.4756.1000), then SP1 is not installed. Sorry, I have no solution to offer you.

Here is the knowledge base article where the Microsoft Office 2010 version numbers are documented: http://support.microsoft.com/kb/2121559.

Hopefully you have stepped into the same little trap as I did, and SP1 installed fine after all. Pity that the Service Pack package is not more intelligent and does not provide a more useful error message. Oh well, life on planet Earth is not perfect Winking smile

Keywords: Microsoft Office 2010, Service Pack 1

Skype Exiting after Login

I upgraded to Skype 5.3 today, only to find that it exits (crashes silently?) immediately after logging in. I am using a 64-bit edition of Windows 7 and have gotten used to all kinds software quirks popping with installation.

It took me a while to figure out that the problem lay with the Skype shortcut created during installation—for some reason it was set to run Skype in compatibility mode with Windows Vista 2 (Service Pack 2).

I disabled the compatibility mode, and Skype was happy again!

Skype53

Welcome back to Microsoft Office Document Imaging!

If you are like me, then you love the flexibility that Microsoft Office Document Imaging (MODI) provides (or rather “used to provide”) for scanning multiple pages to a single TIFF file. MODI was installed as an optional tool with Microsoft Office all these years, but was discontinued with Microsoft Office 2010.

On more than one occasion in the month couple of months, I have googled high and low for something similar in Office 2010. The “best” solution that I could find was Windows Fax and Scan (part of Windows 7), but frankly speaking, its features  pales in comparison. And then I thought I would google one more time today…

I was pleasantly surprised to see that the Microsoft Knowledgebase now has an article that gives instructions to retain MODI when installing Office 2010. The steps are really quite obvious and simple—it boils down to running the Office 2007 setup and installing MODI—but I have avoided such a mix of components from different editions of Office. But I went ahead and did as instructed, and am very pleased with the result.

Here is a link to the article in the Microsoft Knowledgebase; scroll down to the bottom of the page for the instructions:
http://support.microsoft.com/kb/982760

Keywords: Microsoft Office Document Imaging, Office 2010

Error when opening a Office Web Apps (SkyDrive) notebook in OneNote

This article deals with the folling error message:To open this notebook, your computer must be running a supported version of Microsoft OneNote and a browser that supports opening files directly from the Office Web Apps.”

I am relatively new to Microsoft OneNote (now part of all Microsoft Office 2010 suites) and totally new to Microsoft Office Web Apps. The Office Web Apps service was introduced by Microsoft a couple of weeks ago, and holds great promise for sharing information. Personally, I find the service extremely useful for jotting down notes and building simple spreadsheets when I am out of the office – it is great to have Office (albeit a scaled down version) available at my fingertips wherever I go). Documents are saved in the “cloud” on Microsoft’s SkyDrive, and are accessible from anywhere.

As things go with geeks, the simple stuff is seldom enough and you soon find yourself bumping your head against system boundaries. It seamed logical (and it proved reasonably simple too) to share a OneNote notebook and Excel spreadsheet with my significant other. I created the documents locally, shared them online, and she could access them through her Live ID. I admit that it took a little bit of head scratching to figure out how to share my online documents, but I eventually figured that out.

image The opposite would not work though…

I could create a document (in this case a OneNote notebook) on SkyDrive with ease, but was unable to open it locally (i.e. using OnenNote on my main work computer). It was supposed to be as easy as clicking the Open in OneNote button. But doing that gave an error…

 

 

 

image

To open this notebook, your computer must be running a supported version of Microsoft OneNote and a browser that supports opening files directly from the Office Web Apps.

 

 

 

I tried using Internet Explorer (instead of my default Mozilla Firefox), but the error was the same. It took me a while (Google is my friend) to figure out that the problem was likely due to me running a 64-bit version of Microsoft Office. Some disconnect between Office Web Apps and Microsoft Office still seem to exist in the 64-bit environment. (A related issue exists in Office OneNote 2010 when using the Insert File option, e.g. dragging and dropping a PDF file into OneNote – it currently does not work with the 64-bit version.)

Microsoft will likely be addressing issues like this in due course. In the meantime, I found a work-around for the problem to be opening the online notebook in [my local] OneNote using its URL. Figuring out what the URL is, is not that difficult…

Looking at the notebook that resides on Office Web Apps (i.e. the online notebook that I want to open locally), the URL displayed in my web browser’s address bar is an ASPX (ASP.NET) page:

https://cid-XXXXXXXX.office.live.com/edit.aspx/NameOfOnlineNotebook

where XXXXXXXX is some unique session identifier.

Comparing with a notebook that I am sharing online (i.e. notebook I created locally and then shared online), I found more clues. Right-clicking the notebook and choosing Copy Link to Notebook revealed the following two URLs:

https://cid-XXXXXXXX.office.live.com/edit.aspx/NameOfSharedNotebook

as well as

https://YYYYY.docs.live.net/XXXXXXXX/NameOfSharedNotebook

where YYYYY is some subdomain for my SkyDrive instance.

Using the similarities and differences in the two URLs, I could deduct that the URL to the online notebook should be as follows:

https://YYYYY.docs.live.net/XXXXXXXX/NameOfOnlineNotebook

image I could then simply use the Open command on the File menu, enter the URL for the File Name, and open the notebook :)

 

 

 

Keywords: Microsoft Office, OneNote, Office Web Apps, SkyDrive, 64-bit

MS Outlook error when clicking on a hyperlink

For the umpteenth time today, my Outlook 2007 gave an error when I click on a web link:

General failure. The URL was: ”http://twitter.com”. An error uncured when sending the command to the application

Today’s error followed the installation of Microsoft Expression Web Studio 4. I like using Firefox as my default web browser, and it appears as if the installer messed up some setting related to the default web browser. The problem appears related to an error that I reported earlier.

As I mentioned, this is not the first time this has happened on my computer. The following fix works for me:

  • Close Outlook.
  • Set Internet Explorer as the default web browser. You can do this by running IE, and choosing Internet Options on the Tools menu. On the Programs tab, click Make default.
  • Set Firefox as the default browser again. Do this by running Firefox, and opening the Options… on the Tools menu. On the Advanced tab, select the General sub-tab, and click Check Now [if Firefox is the default browser].

In summary: The problem appears to relate to setting a default browser other than Internet Explorer, and then installing a (Microsoft?) product that meddles with those settings. Re-setting the default browser fixes the problem for me time and again.

Keywords: Microsoft Outlook, Firefox, default browser, error, hyperlink

Fixing the CPU-hungry Bind name server

I administer a number of web servers, mostly CentOS and RedHat Enterprise Linux with cPanel and Web Host Manager. A while back our primary name server (a CentOS server with cPanel & WHM) gave problems when restarting the name service (Bind). The problem seemed like one of insufficient capacity. I was a bit surprised that this could be because we were serving only about 5,000 DNS zones, but nevertheless went ahead with an “upgrade”…

In my infinite wisdom, I used the /scripts/ulimitnamed script to “upgrade” the Bind name server to a version that supposedly supports a very large number of DNS zones. [ Imagine the ego trip thinking that 5,000 zones put us in the “very large” category ;) ] The resulting Bind instance showed up in the process list as named-wrapper (used to named in originally). The new process used quite a bit more resources than the original, but because it solved the apparent capacity problem and that the box in question was primarily a name server (and some server monitoring scripts etc.), I thought the “upgrade” was a job well done.

In recent weeks I noticed a steady increase in CPU usage. This came to a boiling point when the named-wrapper process suddenly started to consume 95% plus CPU for extended periods of time. Domain lookups were slowing down, and newly added DNS zones (on other web servers in the cluster) were getting lost. At the same time (and even before when the initial problem occurred) our secondary name server was working without any problems.

Some googling (I guess I could have binged too) revealed some general unhappiness with the performance of named-wrapper. More than one users on the cPanel forum previously stated that they wanted to revert from the high-capacity version of Bind back to the “standard” version. There were some speculations how to do this, but no definitive method.

I tried to piece the puzzle together, and got lucky. Here is how I “downgraded” (quite graciously may I add) from named-wrapper to named:

  1. Stopped the name service:
    service named stop
  2. Replaced the named startup script (/etc/init.d/named) with the original. (I did this by copying it from the secondary name server to the primary server.)
  3. Forced a reinstall of bind-libs
    yum reinstall bind-libs
  4. Restarted the name service
    service named start

The above procedure solved my problem completely. CPU usage is down to almost nothing, and there are no problems starting the name service. (Why the initial apparent capacity problem occurred, I still do not know.) I hope posting it here may help someone else too.

The morals of the story:

  1. Do not blindly use the utilities in the /scripts folder. Useful as many of them may be, they are generally not well documented and can be dangerous. Be sure what the use of a particular script may be before using it. (The /scripts/ulimitnamed script will reportedly be deprecated in an upcoming version of cPanel – someone else learned the same lesson it seems.)
  2. Google is your friend. Search and search some more. The chances are someone else have experienced the same problem before and posted a
  3. solution somewhere.

Keywords: named, named-wrapper, Bind, cPanel, cpu, ulimitnamed

The mystery of the disappearing TortoiseSVN icon overlays

Using a 64-bit version of Windows 7, I noticed that some of my programs did not display the TortoiseSVN icon overlays and lacked the SVN context menus. A bit of sleuthing revealed the (somewhat) obvious: 32-bit application require the 32-bit version of TortoiseSVN to display to integrate with TortoiseSVN.

According to the TortoiseSVN website, one can safely install both the 32-bit and 64-bit versions side-by-side. The 64-bit version will provide the necessary services to 64-bit applications (including Windows itself), and the 32-bit version will service the 32-bit application.

So, I installed the 32-bit version too. To my dismay though, the TortoiseSVN icon overlays completely disappeared. The shell integration functions (SVN Update, SVN Commit, etc.) were all there and working fine, but the icon overlays were simply missing.

Googling around confirmed that others have been experiencing problems with missing icon overlays too. There were many suggestions, generally dealing with uninstalling and rebooting, changing the status cache settings, and even deleting the icon cache itself. Nothing worked for me.

Several (too many to count) uninstall, reboot, install, and reboot sessions followed with little success. At one stage I got the icon overlays to display on the left tree panel in Windows Explorer, but on the right-side content window they remained gone. Weird.

In the end, I solved the problem uninstalling TortoiseSVN (both versions), rebooting, and then deleting all Windows Registry that made reference to “tortoise”. Reinstalling and two reboots later, all was working like a charm :)

I cannot remember when last I rebooting my computer this many times…

Keywords: TortoiseSVN, icon overlays, Windows 7 64-bit, shell integration

Web links not working in Outlook

The other morning (following a massive Windows update the night before) I was greeted with an error whenever I clicked on a link in email. Outlook simply said “This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.”

I promptly consulted my good friend Google for advice, and found a couple of relevant suggestions. The cause of the problem appeared to be related to the default browser setting in Windows (by the way, I use Firefox as my main browser) being damaged (by the Windows update?). Suggestions ranged from setting the default programs in Windows, to editing the Windows Registry. None of that worked for me though. I suspect that might have had to do with me running

Windows 7 (at the time still the Release Candidate), and the information out there relating to Windows Vista and older operating systems.

What did fix the problem was to simply run Internet Explorer and set it as the default web browser (Tools / Internet options / Programs / Make Default), and then run Firefox and set it as the default web browser (Tools / Options / Advanced / General / Check Now).

Really easy in the end!

Keywords: Outlook, Firefox, error, restrictions

How to use Windows Live Writer with WordPress

In my limited dealings (to date) with WordPress, one thing quickly become abundantly clear: the formatting of posts using the built-in editor leaves a lot to be desired. The editor itself seems pretty good, but WordPress somehow messes things up. You can format your text all you want, and the next thing you see is that WordPress has removed paragraph breaks! Frustrating to say the least.

Enter Windows Live Writer

Windows Live Writer offer a convenient way of editing your posts right from your desktop. It is not only easy to use, but it does not suffer from the mentioned annoying formatting issues.

Getting Windows Live Writer to work with WordPress is really

easy to do:

  1. Log in to your WordPress admin console. Under Settings, go to Writing and enable the XML-RPC option. If you do not do this, then your WordPress installation will not accept connections from Windows Live Writer.
  2. Download Windows Live Writer from the Windows Live website, install it on your computer, and add an Account for your WordPress blog on the Tools menu.

Keywords: WordPress, Windows Live Writer, XML-RPC, Settings