As a common rule, most individuals ought to all the time set up 32-bit model of Microsoft Workplace. There are some conditions the place you’d profit from 64-bit model of Workplace, however these instances are uncommon and largely apply to builders or people who work with unusually massive information. Relating to putting in Workplace, ensure you don’t run each 64-bit and 32-bit variations of Workplace concurrently on a pc as a result of this could trigger severe compatibility points. Should you put in the inaccurate model (e.g. 64-bit) by mistake, simply uninstall that model after which set up the right model (e.g. 32-bit).
Causes to decide on the 64-bit model
Computer systems working 64-bit variations of Home windows typically have extra sources corresponding to processing energy and reminiscence, than their 32-bit predecessors. Additionally, 64-bit functions can entry extra reminiscence than 32-bit functions (as much as 18.4 million Petabytes). Subsequently, in case your eventualities embody massive information and/or working with massive information units and your laptop is working 64-bit model of Home windows, 64-bit is the appropriate alternative when:
- You’re working with massive information units, like enterprise-scale Excel workbooks with complicated calculations, many pivot tables, information connections to exterior databases, Energy Pivot, 3D Map, Energy View, or Get & Rework. The 64-bit model of Workplace could carry out higher in these instances. See, Excel specs and limits, Information Mannequin specification and limits, and Reminiscence utilization within the 32-bit version of Excel.
- You’re working with extraordinarily massive photos, movies, or animations in PowerPoint. The 64-bit model of Workplace could also be higher suited to deal with these complicated slide decks.
- You’re working with information over 2 GB in Mission, particularly if the undertaking has many sub-projects.
- You’re growing in-house Workplace options like add-ins or document-level customization. Utilizing the 64-bit model of Workplace helps you to ship a 64-bit model of these options in addition to a 32-bit model. In-house Workplace answer builders ought to have entry to the 64-bit Workplace 2016 for testing and updating these options.
- You’re working with the Massive Quantity information kind in Entry, and whereas this information kind is supported by 32-bit Entry, you might even see sudden outcomes when executing code or expressions that use native 32-bit VBA libraries. 64-bit VBA supplies the LongLong information kind which absolutely helps massive numbers. For extra info, see Utilizing the Massive Quantity information kind.
Causes to decide on the 32-bit model
Be aware: In case you have 32-bit Home windows, you may solely set up 32-bit Workplace. In case you have 64-bit Home windows, you may set up 32-bit Workplace or 64-bit Workplace.
IT Professionals and builders particularly, must also evaluation the next conditions the place the 32-bit model of Workplace remains to be the only option for you or your group.
- You could have 32-bit COM Add-ins with no 64-bit different. You possibly can proceed to run 32-bit COM add-ins in 32-bit Workplace on 64-bit Home windows. You may also strive contacting the COM Add-in vendor and requesting a 64-bit model.
- You utilize 32-bit controls with no 64-bit different. You possibly can proceed to run 32-bit controls in 32-bit Workplace like Microsoft Home windows Frequent Controls (Mscomctl.ocx, comctl.ocx), or any current Third-party 32-bit controls.
- Your VBA code makes use of Declare statements Most VBA code doesn’t want to vary when utilizing in 64-bit or 32-bit, except you utilize Declare statements to name Home windows API utilizing 32-bit information varieties like lengthy, for pointers and handles. Typically, including PtrSafe to the Declare and changing lengthy with LongPtr will make the Declare assertion appropriate with each 32- and 64-bit. Nevertheless this won’t be attainable in uncommon instances the place there isn’t a 64-bit API to Declare. For extra details about what VBA modifications are wanted to make it run on 64-bit Workplace, see 64-Bit Visible Primary for Functions Overview.
- You could have 32-bit MAPI functions for Outlook. With a rising variety of 64-bit Outlook prospects, rebuilding 32-bit MAPI functions, add-ins, or macros for 64-bit Outlook is the advisable choice, but when wanted you may proceed to run them with 32-bit Outlook solely, as effectively. To find out about getting ready Outlook functions for each 32-bit and 64-bit platforms, see Constructing MAPI Functions on 32-Bit and 64-Bit Platforms and the Outlook MAPI Reference.
- You’re activating a 32-bit OLE server or object. You possibly can proceed to run your 32-bit OLE Server utility with a 32-bit model of Workplace put in.
- You’re utilizing SharePoint Server 2010 and also you want the Edit in Datasheet view. You possibly can proceed to make use of the Edit in Datasheet view performance in SharePoint Server 2010 with 32-bit Workplace.
- You want 32-bit Microsoft Entry .mde, .ade, and .accde database information. When you can recompile 32-bit .mde, .ade, and .accde information to make them 64-bit appropriate, you may proceed to run 32-bit .mde, .ade, and .accde information in 32-bit Entry.
- You require Legacy Equation Editor or WLL (Phrase Add-in libraries) information in Phrase. You possibly can proceed to make use of Legacy Phrase Equation Editor and run WLL information in 32-bit Phrase.
- You could have an previous embedded media file in your PowerPoint presentation with no accessible 64-bit codec.
As I discussed earlier, it’s uncommon that you’d want to put in 64-bit model of Workplace. The commonest eventualities that require 64-bit Workplace are working with extraordinarily massive information, corresponding to information bigger than 2GB in Microsoft Mission or extraordinarily massive movies, photos, or animations in PowerPoint. In case you are nonetheless unsure which model of Workplace to make use of, then set up the 32-bit model as a result of that has been the advisable model of Workplace by Microsoft for a really very long time and it’s the safer alternative that’s much less prone to trigger issues.
