32 bit vs 64 bit microsoft office project

32 bit vs 64 bit microsoft office project windows#

Office Watch has been repeatedly told by Microsoft (and others with considerable expertise) that 64-bit Office is faster than the 32-bit version. “ We have some tests that run a bit faster on 64-bit Excel, and other tests that run a bit slower on 64-bit Excel.“ He directed us to a 2009 Microsoft post which says that 64-bit Excel was the same or even slower than the 32-bit version. Greg also had some comments about the relative performance of 32 and 64-bit Office. The lack of Common Controls is unforgivable – the company has had plenty of time to do it. It’s true that Microsoft itself hasn’t enabled compatibility for 64-bit Office.

32 bit vs 64 bit microsoft office project windows#

If not, then most users are better served, and will be for some time to come, by 32-bit Excel on 64-bit Windows with at least 4GB. If you can show that 64-bit Excel is substantially faster than 32-bit Excel on 64-bit Windows with the same amount of RAM, then yes 64-bit Excel can be rightly recommended for general use.

Running 32-bit Excel on 64-bit Windows with at least 4GB and preferably 8GB or more can be a big improvement since 64-bit Windows can give each 32-bit program 2GB, where 32-bit Windows slices up 2GB among them all. Without 64-bit Excel, those projects would require making the source files - they were database extracts - smaller, or streaming them in to Excel with the Input function and working with the data piecemeal. 64-bit Excel is great for huge files that expand to make Excel use more than 2GB. Many of them make 32-bit Windows API calls or use 32-bit libraries or controls. Finally, there are gobs upon gobs of abandonware Excel add-ins and macros in use today. Next, about a zillion ActiveX controls were made for office with 32-bit COM VB. To ensure compatibility with 64-bit Excel, I had to remove it and roll my own progress bar control. I had used the progress bar from Common Controls. When Excel 2010 came out, I was on a contract at Amazon, automating spreadsheets used by vendors to upload products to sell on Amazon. Add-ins and macros that use them won’t work. A 64-bit version of the Common Controls may never happen. ” 64-bit Office isn’t compatible with the Common Controls.

Greg L writes with another viewpoint on the great ” Office 32 vs 64-bit debate”