All posts by nadyne

Q&A: Can I import my .PST files into Outlook:Mac?

Dean asked:

I am converting from Office:Windows 2010. Do my current .pst files work on Outlook:Mac 2011? If not, how do I convert from Office:Windows to Office:Mac?

Yes!  If you have a .PST file from Outlook for Windows (created using Outlook 2003 or later), you can import it into Outlook:Mac.  Just transfer the .PST file from your Windows computer to your Mac (such as putting it on a thumb drive), and then go to File -> Import in Outlook:Mac.

For full instructions for how to import your .PST file into Outlook:Mac, read this help file: Import a .pst file from Outlook for Windows.

Q&A: does Excel:Mac 2011 have pivot tables?

Via email, I got this kinda perplexing question:

i heard that the new excel doesn’t have pivot tables – why are you keeping macs out of business???

I’m trying to figure out where this came from, and I’m not quite sure.  Excel 2008 already had pivot table support (to get started with pivot tables in Excel 2008, check out Create a pivot table report in the Excel help, and there’s a Lynda.com tutorial for it too).  My only guess about this confusion is that someone might have misunderstood Walt Mossberg’s review, in which he noted that Office:Mac 2011 doesn’t have all of the features of Office 2010 for Windows, such as pivot charts in Excel.

In Excel:Mac 2011, we made a big investment in improving matters for our power users, which includes some great improvements to pivot tables.  If you’re an Excel guru, check it out and tell us what you think.  I think that Excel gurus will especially appreciate the performance improvements.

Q&A: why do I have to quit my web browser when I install Office:Mac 2011?

Via email, I got this question:

I installed Office 2011 last night.  I had Safari and Firefox open, but was forced to quit them during the Office install.  Why?

During the installation of Office:Mac, we install fonts.  Web browsers, since they’re heavily reliant on fonts, don’t particularly like it when you change fonts out from under them while they’re running.  If you install a font that the browser is using, then it’s likely to not display that font properly until you restart your browser.  To avoid this kind of issue, we simply ask you to close down your browser for a couple of minutes.

On a related note, Jim asked this in the comments thread in my post about latest Office 2008 and 2004 updates:

Why does the update to Office insist that I quit Safari????

Our updater uses some of the same code as our installer, and that’s one of the pieces we reuse.  We reuse that particular piece of code because an update could include font updates.

user research at MacBU

Inspired partially by yesterday’s post, which included a mention of how I imported all of my existing data into Outlook, I decided to clean up my oh-so-messy Documents folders. We won’t discuss how much stuff was in there that I haven’t needed in years.

In that folder, I found a presentation that I gave earlier this year at the San José State University student chapter of the Human Factors and Ergonomics Society.  This presentation gives me an excuse to try out embedding a PowerPoint presentation that’s stored on SkyDrive in my blog, so here goes:

Q&A: should I import my Entourage identity to Outlook:Mac?

Via mail, I got this question:

I have Entourage EWS running now off Exchange Server 2010 and will be upgrading to Outlook. Do you recommend:
a) doing a fresh download of all mail and other data from the server when setting up Outlook, or
b) importing the data from Entourage into Outlook locally?

With a fresh download, you’re starting off with a clean slate.  This is important for someone like me who’s been using Entourage since 2004, since gunk can build up in your database.  But, with an import, you get the goodness of keeping all of your local data.  Since I have been using Entourage for years, and at one point I had a teensy Exchange account size limit, I’ve got lots upon lots of local data.

With every release, I’ve gotten into the habit of starting off with a clean slate.  For this release, that means that I first saved out all of my local mail (that’s the only local data that I have: all of my contacts, calendar, and so on live in Exchange).  I let Outlook start off with a clean slate, download my mail from Exchange and from my IMAP accounts, and then imported the local data.

To do this, in Entourage for Web Services, I saved all my local mail folders by dragging them out of Entourage and onto my desktop.  That creates .mbox files, which can then be imported into Outlook (as well as any other mail client which supports .mbox files, which is most of them).  I don’t have any other local data other than mail, but I’d do the same if I did have local contacts, calendar, notes, or tasks.

Then, after Outlook had downloaded all of my Exchange and IMAP data, I made sure that it would show my local data.  Go into the Preferences, then select General, and make sure that the box next to “Hide On My Computer folders” is not checked.  Then, I dragged those .mbox files into Outlook.

In my opinion, that’s the best of both worlds: I start fresh and still get to keep my reams and reams of local data.

Q&A: where can I buy Office:Mac 2011?

Someone emailed me to ask:

where can i buy office for mac?

Once we hit our release date of Tuesday, 26 October 2010, you’ll have plenty of options.  This list is nowhere near comprehensive, and is entirely US-focused because that’s where I live and thus it’s what I know about.  Commenters, feel free to add in other options.

For those of you who want to go to a bricks’n’mortar store to buy it, your friendly local Apple Store and Best Buy will have it.  Other authorised Apple outlets are likely to have it too, and I’ve already seen shelf signs for it at my local Fry’s.

Online, the fine folks at Amazon are accepting pre-orders.  In fact, as of this writing, it looks like they’ve got some discounts from the price for the Home and Student Edition ($10 off the single-license version and $20 off the three-license version), as well as for the Home and Business Edition ($25 off the single-license and $40 off the two-license version).

Walt Mossberg: “by far the best Mac version of the suite I’ve used”

Walt Mossberg of the Wall Street Journal has reviewed Office:Mac 2011, with a bit of an Outlook pun: Mac Users Are Getting New Outlook From Rival.  It starts out by saying that “[a] new, faster, better version of Microsoft Office is coming out Oct. 26”, and wraps up by saying that the “new Mac Office is by far the best Mac version of the suite I’ve used, and I can recommend it”.

Sandwiched between those two stellar lines, Mossberg notes that performance is “dramatically snappier” and says that Outlook is “fast and capable”.  He also notes improved compatibility and file fidelity between the two platforms, as well as some of our Mac-only features like dynamic reordering and Word’s full-screen view.

Getting Office:Mac 2011 out the door has been a long road.  It’s fantastic to see all of these great reviews come in.  I can’t wait to hear what everyone thinks when it finally hits store shelves on October 26.

Q&A: Why doesn’t Outlook:Mac sync directly with mobile devices?

Via email, I got this question:

entourage used to sync directly with mobile devices like the palm, but replaced it in ent2008 with apple’s sync services. outlook does this too. why don’t you sync directly with mobile devices instead of doing through ical?

There’s two major reasons for supporting Sync Services instead of writing our own support: time, and being a good Apple citizen.

Today, there are dozens of mobile device manufacturers out there, and hundreds of different mobile devices.  Before the introduction of Sync Services, we had to write our own support for each of those devices.  There’s little commonality between the APIs that devices from different manufacturers use, so it’s a big investment in development time to support various multiple devices.  Further, as devices evolve, updates to the devices require updates to sync support.  Devices come out whenever they come out, which means that we had to be prepared at any time to start working on support for a new device.

The introduction of Sync Services in 10.2 offered up an opportunity for us to reduce our development costs, since we would only have to support a single sync instead of a myriad of different syncs.  Additionally, it gave us the chance to continue to be a good Apple citizen.  One of the major changes that Sync Services introduced is a back-end database called The Truth.  Apple’s own apps write to The Truth, and other clients can also read and write to this central database too.  That allows us to share our data with other clients, and to view data from other clients as well.

For more information about our Sync Services support and where we’re going from here, you can read this earlier blog post of mine: Q&A: Can I sync my Outlook:Mac 2011 calendar with Sync Services?

Office:Mac 2008 (12.2.7) and Office:Mac 2004 (11.6.1) updates available now

Update Tuesday is here, and brings Office:Mac updates.

The latest version of Office 2008 is 12.2.7.  This update has security and stability improvements across the suite.  For Entourage users, there are improvements to Exchange support.  If you’re using Entourage for Web Services, the 12.2.7 update will update it to 13.0.7.  Full details about this update are available in the update’s Knowledge Base article.

The latest version of Office 2004 is 11.6.1.  This update has security improvements across the suite.  Full details about the update are available in its Knowledge Base article.

We also updated the Open XML File Format Converter.  It’s now at 1.1.7, and the update has security improvements too.  Its Knowledge Base article has the details.

To update, you can go to the Help menu of any Office application and then select “Check for Updates”.  Alternately, you can download directly from Mactopia.

Office:Mac 2011 getting started videos now available

In anticipation of the upcoming October 26 launch of Office:Mac 2011, we’re updating our website with new content.  The latest update is a series of quick videos to introduce you to each of the applications.  These are all produced in-house, even down to the voiceovers: those are all MacBU employees that you hear on the videos.

Here’s links to the videos for each app: