« Posts tagged Office 2010

Updated: Office Apps Stuck on Downloading Files from Network Shares

For a while now I was having problems opening Word and Excel (2007 and 2010) documents on my work computer. Most of the time everything would work, but every now-and-again I’d go to open something and Word or Excel would report that it was “Downloading <filename>”, and simply get stuck. Although I could click the little ‘X’ to cancel and close the window, the process for either Word or Excel would stay active, and any attempts to kill it would fail. In the end, I’d have to hard power off the computer to get it to shutdown, and then do a cold boot.

'Downloading' an Excel Workbook

Oh, 'Downloading' message, how I hate thee.

I wasn’t really bothered by it until a few of my users started reporting the same problem. I had a look in to it, and after a lot of fiddling, came across two Microsoft Knowledge Base articles that eventually led me to a solution.

An Office program is slow or may appear to stop responding (hang) when you open a file from a network location

The program stops responding when you try to open or to save a file in an Office 2002 program, in an Office 2003 program and in an Office 2007 program

By adding the registry value from the first KB article linked above (EnableShellDataCaching), and by removing the Group Policy object that was creating a persistent drive mapping and replacing it with a login script (below) to map the drive, I haven’t had any further reports of the problem.

REM Login Script – Paste these lines in to a batch file, and add that .bat file to a GPO

net use z: /delete
net use z: \10.0.0.100share
Note the use of the IP Address, rather than the Fully Qualified Domain Name (FQDN) – this was essential to getting things working in the end.

Exchange Sync With Android: Possible, But Not Pretty

One of the things I loved about my old iPhone was the built-in Exchange sync. I could sync my email, my calendar, and even my contacts (although I only did the first two). Life was good.

After moving to the Android platform, however, I was disappointed to discover that although an Exchange email app was included, it wouldn’t allow you to directly sync an Exchanged-based calendar. A little searching provided a way, though.

  1. Make sure you’re running Office 2003 or 2007 – if you have the Office 2010 Beta installed, it won’t work. If you still want to sync, uninstall 2010 and install 2003 or 2007, then follow the Special Note at the end of the post.
  2. Download the Google Calendar Sync tool.
  3. Install, follow on-screen instructions.
  4. ???
  5. Profit!

Now it should be noted that I did this, and at first it didn’t work as I was using Office 2010 Beta 2. Even after uninstalling it and installing Office 2007, I still couldn’t sync and received this error:

Could not connect to Microsoft Outlook: error -2147319779

A little searching turned up this link, which contained a hint at the solution. When you install Office 2010, it creates the following registry key:

HKEY_CLASSES_ROOTTypeLib’{00062FFF-0000-0000-C000-000000000046}9.4

In the same key, there should also be a ’9.3′ entry. With Office 2010 uninstalled, you can safely remove the ’9.4′ key. Now, restart Google Calendar Sync, and everything should work just fine.

One major caveat with this solution is that your computer has to be up-and-running for the calendar to actually synchronize – fortunately, this isn’t much of a problem if you’re the only one updating your calendar. With any luck, though, Google will eventually support full Exchange syncing with Android.

Edit: I probably should point out that this is for ROMs without official Exchange support (such as Cyanogenmod, which syncs Exchange mail, but not the calendar). Some official ROMs, like HTC’s, actually include Exchange calendar syncing out-of-box.

Update: There’s an APK floating around that gives you the Exchange (Corporate) Calendar. I won’t link it here, but a Google search for “CorpCal.apk” should give you what you need.

Further Update: Froyo will feature native Exchange Calendar sync, so CorpCal will be rendered moot when the update finally hits.

Even Further Update: Froyo, which has been released OTA for the Nexus One, does in fact feature native Calendar syncing with Exchange. This article is handy if you’re stuck on an older ROM, but if not, just use the official method.

Free Office 2010 Offer? Sorry, U.S. only… (for now?)

Neowin is reporting on a special offer from Microsoft via Connect of the chance to test Office 2010 on a laptop provided by Microsoft. As a bonus, when the six month term is up, you get a free copy of Office 2010. Pretty sweet, huh?

Unfortunately, as I was reading the details on the Connect side of things, I came across this:

Q: Is this open to people outside the U.S.?
A: No, this is a U.S.-based program right now. It may be rolled out to other markets at a later time.

There is a glimmer of hope, however giving their previous track record of restricting special offers to the U.S., it’s not likely to happen. Sometimes I think I should rent an apartment three hours to the south (just across the border in to Washington State) just so I can get in on these things….