TekRevue

  • HOME
  • MAC
  • macOS MOJAVE
  • iOS 12
  • WINDOWS
  • MOBILE
  • GAMES
  • REVIEWS
  • EDITORIALS
  • TIPS
    • Windows
    • Mac
    • Mobile
  • Twitter
  • Facebook
  • Google+
  • Feed

Tips / Windows

How to Choose Between the 32-bit and 64-bit Versions of Office

By Jim Tanous on August 19, 2013 at 5:12 AM • @JimTanous

Office 32-bit vs 64-bit

In the early days of 64-bit versions of Windows, software compatibility issues caused headaches for all but the most experienced users. Software and drivers alike had to be updated to support the 64-bit architecture, and it was widely recommended that users stick to the 32-bit variety of Microsoft’s operating system.

That all changed with Windows 7. Built-in emulation for 32-bit software in a 64-bit environment and widespread driver support made the 64-bit version of Windows a seamless experience for most users. This was important because a 64-bit version of Windows was required to access more than 3 GB of system RAM. As a result, most Windows users on modern PCs now run the 64-bit version of Windows 7 or 8. But there’s still one application you should run in 32-bit mode: Office.

Microsoft Office 2010 and 2013 come in both 32- and 64-bit varieties, and most licenses give users the choice of which one to install. Those still running 32-bit versions of Windows will be limited to 32-bit Office, but 64-bit Windows users may be tempted to choose 64-bit Office. For most users, this is not recommended.

The 64-bit versions of Office 2010 and 2013 do indeed have a potentially important benefit: they allow users to work with extremely large Excel spreadsheets and Project databases. The 32-bit version places hard caps on the size of these items at 2 GB (a total virtual address space which includes the file itself, the application, and any running add-ins). There are no practical limits on file size with the 64-bit version, allowing for enormous spreadsheets and databases. While this is a crucial factor for a very few expert Office users (likely in a large enterprise setting), most users won’t come anywhere near the file size limits imposed by the 32-bit version.

Office 32-bit vs 64-bit

There’s also a slight performance boost to using 64-bit Office on a modern PC running 64-bit Windows, but we really want to stress the slight part of this statement. Most users will not notice the difference in performance between 32- and 64-bit versions of Office on the same PC, and other factors such as the speed of the system drive and the amount of available system memory will both result in a significantly more appreciable performance boost.

But the pros of 64-bit Office may be outweighed by the cons. If you determine that you need the 64-bit version of Office, you’ll need to prepare for a few drawbacks:

    • Some features simply aren’t available in the 64-bit version of Office (such as the Word Legacy Equation Editor and Word Add-In Libraries).
    • Older VBA code, often crucial for corporate spreadsheets, won’t run in a 64-bit environment unless it has been updated.
    • Third party add-ins won’t run unless they have been specifically updated to support the 64-bit version of Office.
    • Some Access database files created in the 32-bit version of Office can’t be used with the 64-bit version. They must be recompiled to support the 64-bit version using the original source database (which may not always be available).
    • Many add-ins and macros for Outlook won’t work in the 64-bit version.

These limitations of the 64-bit version of Office may cause unpredictable issues for many users, especially those in business environments. Therefore, unless you’re one of the very few users with gigantic Excel and Project files larger than 2 GB, sticking with the 32-bit version of Office will provide a much less frustrating experience with no appreciable difference in performance.

On the other hand, if you plan to run a completely vanilla installation of Office with no add-ins, or if you’ve verified that your required add-ins are 64-bit compatible, you can certainly try the 64-bit version of Office. Just be aware of the compatibility issues if you’re sharing files with other users.

Microsoft expects that 64-bit versions of Office will one day become the norm, just as it did for Windows, but, as of 2013, we’re not there yet.

Share this:

  • Facebook
  • Twitter
  • LinkedIn
  • Reddit
  • Pinterest
  • Email

  • Categories: Tips / Windows
  • Tags: #32-bit #64-bit #Microsoft Office #Microsoft Office 2013 #Tips #Windows

Sign Up for the TekRevue Weekly Digest

Read more in Tips or Windows on TekRevue

  • windows 10 lock screen tips
    How to Turn Off Windows 10 Lock Screen Tips

    Filed Under: Windows

  • parallels custom touch bar
    Parallels Desktop: Using XML to Create Custom Touch Bar Buttons for Windows Apps

    Filed Under: Tips

  • av1 windows 10
    How to Play AV1 Videos in Windows 10 With the Free AV1 Codec

    Filed Under: Windows

Search

Related Articles

  • xbox games with gold
    The Complete Xbox Games with Gold List and Details
  • parallels custom touch bar
    Parallels Desktop: Using XML to Create Custom Touch Bar Buttons for Windows Apps
  • hide app mac
    How to Hide Mac Apps in macOS via the Terminal

Connect with TekRevue

  • TekRevue on Twitter
  • TekRevue on Facebook
  • Cheats
  • Contributor
  • Deals
  • Distractions
  • Editorials
  • Gadgets
  • Games
  • Gaming
  • Giveaway
  • Hardware
  • Home Theater
  • Mac
  • Mobile
  • News
  • Podcast
  • Reviews
  • Sponsor
  • More in Tips
  • Windows
  • parallels custom touch bar
    Parallels Desktop: Using XML to Create Custom Touch Bar Buttons for Windows Apps
  • plex web shows
    How to Disable Web Shows in Plex
  • siri mac sierra
    Enable ‘Type to Siri’ to Type Your Siri Questions Instead of Speaking
  • chrome auto sign-in
    How to Turn Off Google Chrome Auto Sign-In
  • skype messaging frustration
    How to Turn Off Skype Read Receipts for Mobile and Desktop
  • creative cloud older versions photoshop
    How to Install Older Versions of Creative Cloud Apps
  • search by image mac
    How to Use Google’s Reverse Image Search Feature on the Mac
  • itunes cancel subscription
    How to Cancel App Store Subscriptions via iOS and iTunes
  • youtube dark theme web
    How to Enable the YouTube Dark Theme in a Desktop Browser
  • chrome new look vs old
    How to Switch Back to the Old Chrome Design
  • apple store seoul
    Apple Store Music: How to Find the Songs Played in Apple Stores
  • google drive shared expiration
    How to Set Expiration Dates for Shared Google Drive Files
  • chrome app mode plex
    How to Run Plex and Other Web Apps in Chrome App Mode
  • google docs macbook
    How to See What’s Taking up All of Your Google Storage Space
  • office 365
    How to Deactivate Office 365 on an Old Computer
  • google docs macbook
    How to Clear Formatting in Google Docs
  • photoshop load as layers
    How to Open Multiple Images as Layers in a Single Photoshop Document
  • block notification firefox
    How to Block Website Notifications in Firefox
  • Gmail Tabbed Inbox Update
    Email Tip: How to Block Senders in Gmail
  • center embedded tweet
    Twitter Tip: How to Center Embedded Tweets

Tips

  • Apps
  • Gaming
  • Mac
  • Mobile
  • Online
  • Windows
  • parallels custom touch bar
    Parallels Desktop: Using XML to Create Custom Touch Bar Buttons for Windows Apps
  • replace notepad notepad plus plus
    How to Completely Replace Notepad With Notepad++ in Windows
  • chrome picture-in-picture windows
    How to Use Chrome Picture-in-Picture in Windows 10
  • eartrumpet
    EarTrumpet for Windows 10: A Better Windows Volume Mixer
  • xbox store autoplay video
    How to Turn Off Xbox Store Autoplay Videos on the Xbox One
  • slow steam browser windows
    Here’s One Potential Fix for a Slow Steam Browser in Windows
  • How to Manually Dim the Xbox One Screen
  • xbox one store games
    How to Browse Games by Genre in the Xbox One Store
  • edit video mac mojave
    How to Trim Videos with Quick Look in macOS Mojave
  • disable auto-brightness mac
    How to Disable Auto-Brightness on Your Mac
  • siri touch bar mac
    How to Remove Siri from the Touch Bar
  • mac gpu usage history
    How to View GPU Usage in macOS via Activity Monitor
  • flip camera facetime ios 12
    How to Check FaceTime Data Usage on the iPhone
  • change default card apple pay watch
    Apple Watch: How to Change the Default Apple Pay Card
  • siri mac sierra
    Enable ‘Type to Siri’ to Type Your Siri Questions Instead of Speaking
  • iphone live photo
    How to Convert a Live Photo to a Still Image With a Custom Key Photo
  • plex web shows
    How to Disable Web Shows in Plex
  • youtube dark theme web
    How to Enable the YouTube Dark Theme in a Desktop Browser
  • chrome new look vs old
    How to Switch Back to the Old Chrome Design
  • google drive shared expiration
    How to Set Expiration Dates for Shared Google Drive Files
  • windows 10 lock screen tips
    How to Turn Off Windows 10 Lock Screen Tips
  • av1 windows 10
    How to Play AV1 Videos in Windows 10 With the Free AV1 Codec
  • replace notepad notepad plus plus
    How to Completely Replace Notepad With Notepad++ in Windows
  • windows 10 power user menu
    How to Edit the Power User Menu (Win+X Menu) in Windows 10
Company
  • About TekRevue
  • Get in Touch
  • Sponsorships

Sign Up for the TekRevue Weekly Digest

© TekRevue LLC. All Rights Reserved.

  • TekRevue User Agreement
  • TekRevue Privacy Policy

Built by Blazer Six

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.