Go Back   AnandTech Forums > Software > Software for Windows

Forums
· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· Memory and Storage
· Power Supplies
· Cases & Cooling
· SFF, Notebooks, Pre-Built/Barebones PCs
· Networking
· Peripherals
· General Hardware
· Highly Technical
· Computer Help
· Home Theater PCs
· Consumer Electronics
· Digital and Video Cameras
· Mobile Devices & Gadgets
· Audio/Video & Home Theater
· Software
· Software for Windows
· All Things Apple
· *nix Software
· Operating Systems
· Programming
· PC Gaming
· Console Gaming
· Distributed Computing
· Security
· Social
· Off Topic
· Politics and News
· Discussion Club
· Love and Relationships
· The Garage
· Health and Fitness
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2014
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions
   

Reply
 
Thread Tools
Old 12-12-2012, 05:36 PM   #1
Turbonium
Golden Member
 
Turbonium's Avatar
 
Join Date: Mar 2003
Location: Canada
Posts: 1,732
Default 32-bit Office vs. 64-bit Office

What's the difference, practically speaking? I'm assuming the 64-bit version runs a bit faster, but is it noticeable?

The reason I ask is that I recently installed the 32-bit version of Office 2010 on my dad's new PC (it's the only legitimate copy I had access to), and I'm wondering if it comes with any particular disadvantages when compared to its 64-bit alternative.
Turbonium is offline   Reply With Quote
Old 12-12-2012, 05:49 PM   #2
seepy83
Platinum Member
 
seepy83's Avatar
 
Join Date: Nov 2003
Posts: 2,025
Default

You actually might find, as of right now, that the opposite is true...that the 64-bit version has some disadvantages when compared to 32-bit.

I can't speak for speed or performance, but we're talking about Office applications here...and they aren't terribly demanding of memory resources.

But as far as compatibility is concerned, if you're trying to use any 3rd party add-ins, you'll find that most of them are only compatible with the 32-bit version.

I don't recall the exact text, but the 64-bit installer actually throws up a warning before installation saying something along the lines of "Are you sure you want to install 64-bit office? Because it's really new and not compatible with a lot of stuff, and we really recommend you install 32-bit unless you require 64-bit for some reason."
seepy83 is offline   Reply With Quote
Old 12-12-2012, 05:55 PM   #3
theevilsharpie
Platinum Member
 
Join Date: Nov 2009
Location: Southern California
Posts: 2,320
Default

Quote:
Originally Posted by Turbonium View Post
What's the difference, practically speaking? I'm assuming the 64-bit version runs a bit faster, but is it noticeable?
The 64-bit version of Office can open files larger than 2GB.
theevilsharpie is offline   Reply With Quote
Old 12-12-2012, 06:12 PM   #4
postmortemIA
Diamond Member
 
postmortemIA's Avatar
 
Join Date: Jul 2006
Location: Midwest USA
Posts: 6,505
Default

Quote:
Originally Posted by theevilsharpie View Post
The 64-bit version of Office can open files larger than 2GB.
But it cannot use any 32-bit extensions, as 64-bit binaries must use exclusively 64-bit DLLs.
__________________
D1. Win7 x64 i7-3770 on Z77, HD7850, 2707WFP, 840, X-Fi D2. Win7 x64 E8400 on P35
L1. OSX 10.9 rMBP 13 L2. Vista x86 E1505
M. Galaxy S4

postmortemIA is offline   Reply With Quote
Old 12-12-2012, 06:30 PM   #5
cl-scott
ASUS Support
 
Join Date: Jul 2012
Posts: 457
Default

Basically unless you have some truly massive Excel spreadsheets or especially large Access databases, there is no real benefit to a 64-bit version of Office. Probably very little in the way of drawbacks as well, unless you use third party extensions.
__________________
Scott Billings
Asus Customer Loyalty
Email: cl-scott@asus.com

Opinions expressed are not necessarily those of Asus or Anandtech
cl-scott is offline   Reply With Quote
Old 12-12-2012, 06:35 PM   #6
Chiefcrowe
Diamond Member
 
Chiefcrowe's Avatar
 
Join Date: Sep 2008
Posts: 3,656
Default

I've had one problem with an addon not working right, so I decided to go with 32bit.
Chiefcrowe is offline   Reply With Quote
Old 12-12-2012, 07:41 PM   #7
xSauronx
Lifer
 
xSauronx's Avatar
 
Join Date: Jul 2000
Location: Eastern NC
Posts: 19,318
Default

64 bit may not be supported by add ons or plugins or, if youre in an enterprise environment, all of your software (even other ms software, depending on the update level of other apps)

my uni wont even support the 64 bit version for students.
__________________
LET'S GO 'CANES [they arent going anywhere. ever.]
Free speech doesn't protect speech you like, it protects speech you hate.

Heatware |
xSauronx is offline   Reply With Quote
Old 12-12-2012, 08:36 PM   #8
kleinkinstein
Banned
 
Join Date: Aug 2012
Location: Closet
Posts: 823
Default

Quote:
Originally Posted by theevilsharpie View Post
The 64-bit version of Office can open files larger than 2GB.
Seriously? Either way, that's funny!
kleinkinstein is offline   Reply With Quote
Old 12-12-2012, 09:49 PM   #9
postmortemIA
Diamond Member
 
postmortemIA's Avatar
 
Join Date: Jul 2006
Location: Midwest USA
Posts: 6,505
Default

Quote:
Originally Posted by kleinkinstein View Post
Seriously? Either way, that's funny!
2003 and older Excel had limitation of 65536 rows and 256 columns ...
__________________
D1. Win7 x64 i7-3770 on Z77, HD7850, 2707WFP, 840, X-Fi D2. Win7 x64 E8400 on P35
L1. OSX 10.9 rMBP 13 L2. Vista x86 E1505
M. Galaxy S4

postmortemIA is offline   Reply With Quote
Old 12-12-2012, 11:38 PM   #10
ImDonly1
Platinum Member
 
Join Date: Dec 2004
Posts: 2,189
Default

Quote:
Originally Posted by Turbonium View Post
What's the difference, practically speaking? I'm assuming the 64-bit version runs a bit faster, but is it noticeable?

The reason I ask is that I recently installed the 32-bit version of Office 2010 on my dad's new PC (it's the only legitimate copy I had access to), and I'm wondering if it comes with any particular disadvantages when compared to its 64-bit alternative.
Valid question. I thought the same thing when installing the new office.

Even microsoft on their office website states you should install 32-bit office, unless you know what you are doing and are sure you need 64-bit office. This is mostly because of the plugin support for 64-bit office.

Stay with the 32-bit, you installed the right version.
ImDonly1 is offline   Reply With Quote
Old 12-13-2012, 07:21 AM   #11
GrumpyMan
Diamond Member
 
GrumpyMan's Avatar
 
Join Date: May 2001
Location: Houston, Texas
Posts: 5,001
Default

We tried 64bit Excel at the office but had to go with 32bit due to ASAP utilities not working with it. It's a collection of 300 macros for Excel which we use extensively everyday. Even MS recommends going to 32bit unless of course working with huge databases.
GrumpyMan is online now   Reply With Quote
Old 05-24-2013, 03:14 AM   #12
mark.stewart
Junior Member
 
Join Date: May 2013
Posts: 1
Default 32-bit Office vs. 64-bit Office

Quote:
Originally Posted by Turbonium View Post
What's the difference, practically speaking? I'm assuming the 64-bit version runs a bit faster, but is it noticeable?

The reason I ask is that I recently installed the 32-bit version of Office 2010 on my dad's new PC (it's the only legitimate copy I had access to), and I'm wondering if it comes with any particular disadvantages when compared to its 64-bit alternative.
This post is somewhat dated (we are on to Office Cloud 2013), but this post is middle of Google's first page for the Microsoft inspired question of the century: "32-bit or 64-bit version of Office?"

First up, you did not mention if your father was using 32-bit or 64-bit Windows, Mac or Linux (all or which are Office 2013 friendly). Assume your father is running a 64-bit OS.

For every 64-bit system, 64-bit Office will run much faster.

Memory-hog Office 32-bit apps latch onto the breast of the OS and attempt to force out contenders for a rigidly fixed mere 2.37 GB memory limit. 32-bit circus apps even squabble with each other! As everyone knows, be careful you work one app at a time running old 32-bit Suites of anything, especially of Microsoft Office. Expect daily system crashes.

64-bit apps are not hog-nipple suckers. Microsoft Office 64-bit apps on today's standard 16 GB to 32 GB laptops and desktops have plenty of memory that they interactively cache. Say no more there!

Now comes the REAL PROBLEM: MICROSOFT (no comment on grunt camp D.O.D. "anti-terror interventions" here). Microsoft Corporation has invested billions of dollars of revenue stream in a now outdated and increasingly finite 32-bit fish puddle. To the effect that brazen programmers in TechNet boasted of 64-bit Office release, that they have no problem writing SharePoint apps to intercept 64-bit transactions and "nail them down, ha-ha-ha" with force-fed 32-bit Access and Excel runtimes. While you are enjoying your 64-bit efficiency, NEVER ENJOY clicking on one of those COM popups that insist you click to continue. Task Manager is always awake on my home desktop!

Microsoft has no intention to contain the delinquents it harbors, for now. Microsoft wants to "save money". For large corporations, this is really no problem. For example, our Region 3 Health Care node enables state and provincial Health Authorities to run backbone background Microsoft ("Thug") supported 32-bit mainframes to host 64-bit user terminals. This is critical! Nobody wants their father to die because a nursing station terminal was in crash mode again, so doctors guessed at the wrong medication...

For kids setting up Office on father's home computer, the 32-bit vs 64-bit question is easily answered, and its answer depends on your father's computer sophistication. "Thug" is the term shared with me by a Senior Systems Administrator round Node 3 healthcare: Microsoft will seriously be "working" through various billion dollar reservoirs of redundancy, be working hard to Thug you out on Office 64-bit platforms. No problems, if you know how to dodge redundant popups, including WINDOWS UPDATE popups! Otherwise, okay 'safe': do what the Thug says, and install 32-bit Office... until the lost cow (pig, or whatever you want to call it, as it struggles to remain competitive and ...) makes its way home.

...I run 64-bit Office Cloud 2013 at home. Microsoft is "using" my "experience": popup interventions get steadily more creative, weekdays. Chew on that! We luv u Microsoft. LOL

Last edited by mark.stewart; 05-24-2013 at 03:16 AM.
mark.stewart is offline   Reply With Quote
Old 05-24-2013, 05:52 AM   #13
sad_guy
Banned
 
Join Date: May 2013
Location: India
Posts: 197
Default

^wat
sad_guy is offline   Reply With Quote
Old 05-24-2013, 05:54 AM   #14
smakme7757
Golden Member
 
smakme7757's Avatar
 
Join Date: Nov 2010
Location: Norway
Posts: 1,303
Default

I use 64bit as i don't use addons. So if i for some reason get a malicious addon it won't install as it's most likely written for the 32bit version.
__________________
Currently running Debian 7.1 and Windows 8.1
Blog: http://jack-brennan.com
smakme7757 is offline   Reply With Quote
Old 05-24-2013, 08:41 AM   #15
luv2liv
Golden Member
 
Join Date: Dec 2001
Posts: 1,886
Default

i havent installed office 2010.

but i can tell you my office 97 is ridiculous fast. any word or excel doc open almost instantly. i dont even see any splash screen/logo. i believe office 97 is only available in 32bit flavor)
luv2liv is offline   Reply With Quote
Old 05-24-2013, 01:27 PM   #16
theevilsharpie
Platinum Member
 
Join Date: Nov 2009
Location: Southern California
Posts: 2,320
Default

Quote:
Originally Posted by mark.stewart View Post
For every 64-bit system, 64-bit Office will run much faster.
64-bit Office can open larger files. That's all. There is no appreciable speed difference between the 32-bit and 64-bit versions. There is a speed difference between 32-bit and 64-bit versions of Windows, but that's not Office's doing.

Quote:
Originally Posted by mark.stewart View Post
Memory-hog Office 32-bit apps latch onto the breast of the OS and attempt to force out contenders for a rigidly fixed mere 2.37 GB memory limit.
There is no 2.37GB memory limit. That may be an upper limit on the usable physical memory on certain PCs running a 32-bit version of Windows, but that has nothing to do with Office.

Quote:
Originally Posted by mark.stewart View Post
32-bit circus apps even squabble with each other!
I don't even know what to make of this statement.

Quote:
Originally Posted by mark.stewart View Post
As everyone knows, be careful you work one app at a time running old 32-bit Suites of anything, especially of Microsoft Office. Expect daily system crashes.
What? If you're claiming that you can't run multiple 32-bit applications, you're out of your mind.

Quote:
Originally Posted by mark.stewart View Post
64-bit apps are not hog-nipple suckers. Microsoft Office 64-bit apps on today's standard 16 GB to 32 GB laptops and desktops have plenty of memory that they interactively cache. Say no more there!
Caching is controlled by the operating system, not the application. If you're running a 64-bit OS, it will use all available physical memory as a cache for all applications, including 32-bit applications.

Quote:
Originally Posted by mark.stewart View Post
Now comes the REAL PROBLEM: MICROSOFT (no comment on grunt camp D.O.D. "anti-terror interventions" here). Microsoft Corporation has invested billions of dollars of revenue stream in a now outdated and increasingly finite 32-bit fish puddle. To the effect that brazen programmers in TechNet boasted of 64-bit Office release, that they have no problem writing SharePoint apps to intercept 64-bit transactions and "nail them down, ha-ha-ha" with force-fed 32-bit Access and Excel runtimes. While you are enjoying your 64-bit efficiency, NEVER ENJOY clicking on one of those COM popups that insist you click to continue. Task Manager is always awake on my home desktop!
Microsoft provides 32-bit and 64-bit builds for almost all of their products. They do so (even when it's not strictly necessary) because it costs them practically nothing. Very few commercial software developers developers do the same. I've worked with vertical applications that still have some dependencies on DOS and other 16-bit libraries. Compared to the rest of the ISV landscape, Microsoft does pretty damn well.

And don't even get me started with the garbage applications I've had to support in the healthcare IT field...

The rest of your comments are completely out in left field.
theevilsharpie is offline   Reply With Quote
Old 05-25-2013, 08:53 AM   #17
sad_guy
Banned
 
Join Date: May 2013
Location: India
Posts: 197
Default

dont bother with the spambot..
sad_guy is offline   Reply With Quote
Old 05-25-2013, 09:49 AM   #18
infoiltrator
Senior Member
 
infoiltrator's Avatar
 
Join Date: Feb 2011
Location: Waterbury, CT
Posts: 684
Default

Um, in my limited experience, most people do not notice any difference.
IF you use 32 bit add on programs on a 64 bit install, googling specific programs should define usability.
For a home user a 32 bit install on even a modestly modern computer should accomplish all that is required and is certainly compatible with most applications, if not all.
If Dad is willing to use Office 2010 32 bit (no reason why not, we still use the 32 bit version in work) free from you, he is happy, you should be.
His new computer will be enough faster he will never know any difference if there is one.
fwiw, I cheap out at home with OfficeLibre, though there are occasional glitches. Which are usually my fumbling with compressed emailed docs.
Now if someone would could upgrade our work clients and servers..
__________________
Damn the cost, full build ahead! I wish.

Last edited by infoiltrator; 05-25-2013 at 09:51 AM.
infoiltrator is offline   Reply With Quote
Old 05-25-2013, 06:06 PM   #19
ringtail
Senior Member
 
ringtail's Avatar
 
Join Date: Mar 2012
Location: USA left coast
Posts: 770
Default

For Office 365 (2013 in cloud) I use 64-bit.

As for add-on compatibility, the only add-on I use is MySQL for Excel,and it works just fine on 64-bit Excel.

Last edited by ringtail; 01-03-2014 at 08:26 PM.
ringtail is offline   Reply With Quote
Old 01-03-2014, 09:18 AM   #20
Thierry
Junior Member
 
Join Date: Jan 2014
Posts: 2
Thumbs up I disagree

Well I have to disagree: 64bit is the way to go... BUT maybe not now and surely not now for everyone.

Remember when windows turned 64bit ? Same situation: at first It was strongly recommended NOT to make the switch, but look where we are now ? Who does hesitate when it come to choose between 32bit or 64bit win 7 due to driver compatibility issues.

I am quite probably a special case in this but I made the transition to office 2013 64bits and I am really happy I did.

I run a really HUGE Access database (for an personal user at least) 1.5 Gb of data in accdb files, and some more data in MySQL db (I'm a amateur naturalist and taxonomic database get really big).

Yes I had to rewrite part of my VBA to accommodate the way 64bit changes the game, especially those functions that I use to call external programs through shell commands.

But in exchange I have blazing speed (yes I do see a difference, a big one, maybe it is because I'm one of those few that are in a position to get the benefit, with big files and lots of ram, but I sure do feel the speed difference) and I feel I'm future proof (at least for the next few years).

This second argument is probably the most important to me: future proofing.
Stay 32bit if you will, but when 32bit disappear, and it will eventually, think how hard it will be to catch up.

I prefer to ride with the crest of the wave: bit risky, you can get splashed once in a while, but my: what a ride !
Thierry is offline   Reply With Quote
Old 01-03-2014, 10:08 PM   #21
PliotronX
Diamond Member
 
PliotronX's Avatar
 
Join Date: Oct 1999
Posts: 7,014
Default

Quote:
Originally Posted by Thierry View Post
Well I have to disagree: 64bit is the way to go... BUT maybe not now and surely not now for everyone.

Remember when windows turned 64bit ? Same situation: at first It was strongly recommended NOT to make the switch, but look where we are now ? Who does hesitate when it come to choose between 32bit or 64bit win 7 due to driver compatibility issues.

I am quite probably a special case in this but I made the transition to office 2013 64bits and I am really happy I did.

I run a really HUGE Access database (for an personal user at least) 1.5 Gb of data in accdb files, and some more data in MySQL db (I'm a amateur naturalist and taxonomic database get really big).

Yes I had to rewrite part of my VBA to accommodate the way 64bit changes the game, especially those functions that I use to call external programs through shell commands.

But in exchange I have blazing speed (yes I do see a difference, a big one, maybe it is because I'm one of those few that are in a position to get the benefit, with big files and lots of ram, but I sure do feel the speed difference) and I feel I'm future proof (at least for the next few years).

This second argument is probably the most important to me: future proofing.
Stay 32bit if you will, but when 32bit disappear, and it will eventually, think how hard it will be to catch up.

I prefer to ride with the crest of the wave: bit risky, you can get splashed once in a while, but my: what a ride !
Windows 64-bit still doesn't make a compelling difference, let alone Office. Remember when the original Far Cry came out with a 64-bit patch and enabled new eyecandy that supposedly wasn't possible with 32-bit or would affect performance too much to enable? Ran better in 32-bit. The only real reason for the adoption of 64-bit is addressable RAM, don't kid yourself about performance. It is all marketing.
__________________
. <~~ Do not breathe on the dot.

"Remember when your mom shoved brussel sprouts down your throat regardless of how many times you told her you hated the things? Even when there was god damn corn right there in the fridge? Yeah, thats Microsoft." -shortylickens
PliotronX is online now   Reply With Quote
Old 01-05-2014, 02:08 PM   #22
mechBgon
Super Moderator
Elite Member
 
mechBgon's Avatar
 
Join Date: Oct 1999
Posts: 30,699
Default

There's a lot more ASLR entropy available in 64-bit address space. Whether that's being leveraged completely depends on the version of Windows too. Microsoft has some info on the subject here: http://blogs.technet.com/b/srd/archi...echniques.aspx Best-case scenario, ASLR gets 2048 times as much entropy. Likewise, an attempt to heap-spray the 64-bit address space is not going to get anywhere.

So for myself, since I've had no compatibility problems in the 64-bit version, that's what I'm using since there are some security advantages (which I hope remain purely hypothetical, but that's defense in depth for ya).
mechBgon is offline   Reply With Quote
Old 01-05-2014, 08:26 PM   #23
Remobz
Golden Member
 
Join Date: Jun 2005
Posts: 1,791
Default

Quote:
Originally Posted by mechBgon View Post
There's a lot more ASLR entropy available in 64-bit address space. Whether that's being leveraged completely depends on the version of Windows too. Microsoft has some info on the subject here: http://blogs.technet.com/b/srd/archi...echniques.aspx Best-case scenario, ASLR gets 2048 times as much entropy. Likewise, an attempt to heap-spray the 64-bit address space is not going to get anywhere.

So for myself, since I've had no compatibility problems in the 64-bit version, that's what I'm using since there are some security advantages (which I hope remain purely hypothetical, but that's defense in depth for ya).
Yeah, but does a small business or home user with a 64-bit OS that does not have any demanding tasks for office still need the office 64-bit version?
Remobz is offline   Reply With Quote
Old 01-05-2014, 09:15 PM   #24
Agamar
Golden Member
 
Join Date: Oct 1999
Posts: 1,334
Default

We moved to x64 Office with 2010, and have continued with our 2013 rollout. Over 600 machines without issues. Of course, we have very few Office plugins, except for the Mitel and Panasonic PBX additions for the UCA function of our phone systems. All of those were upgraded to work with x64 Office about 4 months after the first release.
__________________
{Core2Duo 2.66G}{WD Raptor 76G}{8800GTS-OC){4G Corsair VS}
Agamar is offline   Reply With Quote
Old 01-05-2014, 10:43 PM   #25
mechBgon
Super Moderator
Elite Member
 
mechBgon's Avatar
 
Join Date: Oct 1999
Posts: 30,699
Default

Quote:
Originally Posted by Remobz View Post
Yeah, but does a small business or home user with a 64-bit OS that does not have any demanding tasks for office still need the office 64-bit version?
No, but if either version (32 or 64) does what they need, and 64-bit has better ASLR to offer, that's a perk. As I recall, one of the high-profile Office vulnerabilities from the last year did not work whatsoever on 64-bit Office.
mechBgon is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:52 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.