Category Archives: Q&A

your questions, answered

Q&A: What should I do before installing Office:Mac 2011?

Chris asked:

Just started using 2011 through volume license. Is there anything I should have done before installing?

Well, you’ve already installed, so it’s a bit late for you!  But I’ll answer this for anyone else who might be interested.

As a general rule of thumb for any kind of installation or upgrade, you should practice good computer hygiene.  Make sure that you’ve got a recent back-up.  For an Office:Mac installation or upgrade, your backup should include a copy of your Microsoft User Data folder.  This is especially important if you use Entourage, since that’s where all of your Entourage data (email, calendar events, rules, signatures, etc) is stored.

Before you install, you should make the decision about whether you want to keep the old version of Office:Mac around.  For most people, this isn’t necessary at all, although some folks like to keep the old version around just in case — the belt-and-suspenders approach to software.

Also, before you install, think about whether you actually need everything that comes with Office:Mac.  If you aren’t going to use everything, then you can use a custom installation to install only the pieces that you need.  For example, on my home computer, I always do a custom installation.  I know that my Spanish is pretty abysmal, so installing the Spanish proofing tools isn’t going to do me any good.  The proofing tools don’t take up a lot of space, but it somehow makes me feel better that I’m not spending a few MB on my hard drive for them.  I also don’t install the dock icons at home, because I launch all of my applications either automatically on start-up or via Spotlight.  Maybe it’s just that I’m picky, but I always do custom installations on my software (and the OS too!) to see if there’s anything in there that I don’t really need.

When I updated Office:Mac 2008 to Office:Mac 2011 on my laptop at home, I took the opportunity to do some clean-up.  Before upgrading, I gave my Entourage database some love: deleted a bunch of stuff, made sure that my folder structure still made sense, archived stuff that I didn’t need instant access to but still wanted to keep.  This isn’t necessary for an upgrade, but I did it because upgrade time is an excellent time to really take a look at things and figure out if there might be some cruft in there that you can get rid of.  It’s like moving into a new home.  You’re obviously taking most of your existing stuff with you, but it’s also a great chance to clean out your closet and your garage (and your study, and your CD collection, and and and … ) so that you’re not moving stuff that you don’t need any longer.

Q&A: Can I sync my Outlook:Mac calendar with Sync Services?

Chris asked:

Does Outlook 2011 support calendar sync to sync services like Entourage did?

You’re correct: Entourage supported contacts and calendar sync via OS X Sync Services.  Some heavy-duty users experienced recurring issues with self-duplicating items, which made for a pretty painful experience.

To avoid these issues, we rebuilt our Sync Services support from the ground up for Outlook.  We set a very high quality bar, with the goal of avoiding those issues that our Entourage users faced.  For our initial v14.0.0 release, we got there with contacts.  But we didn’t get there with calendar.  Close, but no cigar.  Close wasn’t good enough, so we held off.  We wanted Outlook to be the most awesome Outlook ever.  We decided that we’d rather not support it on the initial release rather than have a version that didn’t meet our standards.

We will add calendar sync in a future update.  I don’t have a date to share yet for that.  The team is working hard on it, and I’ll post when it’s ready.

Q&A: Will the math add-in for Word 2010 come to Word:Mac 2011?

Joe asked:

Are there plans to bring the Math Add-in for Word/Onenote 2010 to Word 2011?

I’m not quite sure what you’re referring to, so I’ll try to cover all of the bases here.

If you’re referring to the Equation Editor in Word 2010, then yes: Word:Mac 2011 allows you to both edit equations created in Word 2010 for Windows, and you can create new equations in Word 2011 too.  Here’s what the Equation Tools tab in the Word:Mac Ribbon looks like (click on it for a full-size version):

Equation Tools
Equation Tools Ribbon in Word:Mac 2011

The Word 2011 help has lots of information about using equations, including plenty of details of how to create equations that will be able to be opened by older versions of Word.

Now, if you’re not talking about our built-in equation editor, then I think that you might be talking about the third-party MathType plug-in from Design Science.  I don’t know what their plans are.  I have my hands full in keeping up with what my team is up to, let alone other software vendors!

Q&A: Does Excel:Mac 2011 still have the Calculator?

Chris asked:

Did they take the GUI formula builder called “Calculator” out of Excel? It was in Excel 98, X, 2004, 2008 and I don’t see it in 2011? In 2008 you would go to “customize toolbars & menus” click on the commands tab and then drag the calculator to your toolbar or menu of choice. The description Excel gave it was “Helps you create basic arithmetic calculations in Excel by offering a layout that is based on a ‘real’ hand-held calculator.”

I wasn’t sure of the history of that calculator, so I asked my colleague Schwieb.  I got lucky: as it turns out, he’s the guy who wrote it originally.  Schwieb said it was added to Excel:Mac in 2001 with the intent of gradually introducing people to formulas.

Now, ten years later, things have changed.  For basic calculator functions, there’s the OS X built-in calculator.  In Excel 2011, there is instead the Formula Builder (which you can see by going to the Formulas tab in Excel and then selecting the Formula Builder icon).  The Formula Builder is much more powerful than the old calculator, and is a great way to learn more about all of the formulas that are in Excel.  I’m pretty good in Excel, but I have to admit that I use the Formula Builder when I can’t recall a formula’s name or its arguments.

The Excel 2011 help has a lot of great information about formulas.  Play around with the Formula Builder and see how it can help you learn more about how to use formulas, too!

Q&A: does Outlook:Mac support server-side rules?

Steve asks:

Can Outlook 2011 manage server side rules on an Exchange server?

We didn’t get that into the initial release.  We’re well aware that it’s something our users would like, so hopefully I’ll be able to share more news about it in the future.

In the interim, Mac users who are in an Exchange 2010 environment are able to create and edit server-side rules via Outlook Web Access (OWA).  OWA 2010 has full support for Safari and Firefox.  This is how I manage my extensive set of server-side rules today.

Q&A: Will Outlook:Mac import my Entourage data?

Via a Twitter direct message, I was asked:

can i import my entourage data into outlook?

Yes!  For those of you who are currently using Entourage, you’ll be able to import your existing Entourage data into Outlook:Mac 2011.  We also support importing from Apple Mail, as well as importing PST files from Outlook for Windows.

You can follow me on twitter here, and you can also follow my team on twitter @officeformac.

Q&A: does PowerPoint:Mac 2011 support “reduce file size”?

Steve asked:

Did PPT get the “reduce file size” ability of the Windows version?

Yes!  In PowerPoint:Mac 2011, go to File -> Reduce File Size.  When you do that, you get the following dialog:

Reduce File Size dialog
PowerPoint 2011: "Reduce File Size" dialog

For more information about reducing your file size, including the options you have for the picture quality, you can check out the help topic for it.

We’ve had a lot of requests for this feature, and here it is!