Should I install the 64 bit version of Microsoft Office 2013?

Phil
Phil used Ask the Experts™
on
My Excel does not recognize LongLong data type needed to run the ActiveX version of Interactive Brokers Trader Workstation Excel dde spreadsheet. It appears that I need to be running a 64 bit version of Microsoft Office. What is the best way to do this and could this cause any problems with existing Office applications that I run.  Thank yo very much!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
You will need to uninstall 32-bit Office (as well as 32-bit Visio and Project if you use them) before installing 64-bit Office. But don't worry--you won't lose your email.

Until Office 2019, Microsoft recommended that people use 32-bit Office. Their concern was whether 3rd party software such as add-ions or controls was compatible with 64-bit Office. Enough time has passed since the first 64-bit Office was released (Office 2010) that all the popular 3rd party add-ins and controls have been converted and many of the less popular ones. You should test for compatibility with your workflow if possible. If not, you'll find soon enough whether there is a problem.

I made the switch to 64-bit about 3 years ago. Other than a few Windows API calls that needed to change, I didn't experience any problems at all--and definitely enjoyed the ability to use Excel with more RAM. The 32-bit Excel was originally limited to 2 GB of memory for application, add-ins and workbooks. Excel 2013 and later became Large Address Aware around 2015, so they could use 3 GB of memory with 32-bit Windows and 4 GB with the more common 64-bit Windows. But 64-bit Excel can use as much memory as you can afford (the limit is thousands of GB).

I helped a client build trading software in Excel VBA a few years ago. He was using the Interactive Brokers Excel add-in to perform his trades, and my software needed to figure out which trades to make.

I could not use Interactive Brokers code as furnished because they had a number of compile errors that had to be fixed (variables not declared and missing subs primarily). Fortunately, it only took an hour or two to patch it up--a process I had to repeat with each new release.

Some of the Interactive Brokers code was obviously based on recorded macros. Other pieces looked quite professional. I did not try to convert IB code between 32 and 64-bit.
PhilPresident

Author

Commented:
Thank you very much, this is wonderful news. The only issue I see is finding the original install CDs and associated license keys. I have a laptop with Office 365, one desktop with Office 2013, and another with Office 2010. Is there a way to do this without the original install media?

Also, if I have unsolvable issues with Interactive Brokers's software, are you interested in a consulting arrangement?

Thanks again for your assistance, you have been most helpful!!
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
I suggest running a tool like BelArc Advisor, Magical Jelly Bean, NirSoft Produkey to make a list of all your CD keys for software on each computer before you start uninstalling software. If you find your Office install media (or borrow them from a friend), you will need these CD keys to re3install & activate the 64-bit Office.

Depending on the version of Office 365 you purchased, you can install Office 2016 on an Office 365 subscription on more than one computer without paying more. If you can't find the media for Office 2010 & 2013, I suggest changing to Office 2016/Office 365 subscription anyway--Excel has been much improved.

Keep posting in this thread if you have problems making the switch.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

PhilPresident

Author

Commented:
Thanks so much. I purchased a 5 PC license for Office 365 and installed it on this system.  It took a while but finally got Outlook and other Office apps working. Do you recommend installing Office 2016? Where do I go to find the install downloads?
PhilPresident

Author

Commented:
I think the version is Office Premium that includes Microsoft Access.
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
Just to be clear, what I call Office 2016/Office 365 is the subscription version of the Office suite. Office 2019 is an older version of those apps.

Microsoft really needs a better name for Office 2016/Office 365. Office 365 is not specific enough because it covers everything from an email only service (no Word or Excel) to multi-tenant Office 2016/Office 365 subscription for up to 5 computers for each of 5 people. Office v.Latest would describe it perfectly.

If you bought the 5 PC version of Office 365, you just need to log into your Office 365 account on each computer and download Office 2016. And I definitely recommend making the upgrade.

You initiate installation from the Office 365 portal. Notice the button at top right of the screenshot below.
Office 365 portal page
PhilPresident

Author

Commented:
When I do that it acts like it doesn't know I already purchased Office 365. I don't see a download for Office 2016
PhilPresident

Author

Commented:
It appears that it doesn't know I already purchased Office 365. I don't see a download for Office 2016.
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
You see the Install Office button to the left of Buy Office 365? That's the button you want to click.
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
I forgot to mention: when you install Office on a computer that used to have 32-bit Office 2010 or 2013, the installer defaults to installing 32-bit Office 2016/Office 365. Make sure you choose a Custom install if you want to switch to 64-bit.
PhilPresident

Author

Commented:
dialog box
Is this just reinstalling Office 365? It doesn't say Office 2016.
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
I have a different license than you do for Office 365, so my experience may not be relevant. I log into the Office 365 portal, as described here: Admin Center overview

If you are still stuck, I suggest posting a question on installing Office 365 Personal (assuming that's what you have) on a computer with an older version of Office.
PhilPresident

Author

Commented:
I uninstalled Office 2013 before installing Microsoft Office 365 Business Premium so there shouldn't be any remnants of the old version. I will do as you suggest to investigate further.  Thanks so much for your assistance, I appreciate it very much.
PhilPresident

Author

Commented:
I checked further and the 64 bit version is installed.
PhilPresident

Author

Commented:
I notice that the 365 version of Excel is significantly slower than my old Excel 2013 and is causing significant problems.  Will installing the 2016 version fix that issue?
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
Microsoft tracks performance of the various versions of Excel, and made a number of improvements to Excel 2016/Office 365. These improvements will not be found in the perpetual license versions Excel 2010, 2013, 2016 and 2019 because they were made after those versions were released. The subscription version does lookups a thousand times faster (on large lookup tables) than previous versions of Excel. It is also faster in filter/copy/paste operations. In addition, 64-bit Excel is much faster than 32-bit Excel when you work with large workbooks because it can use more RAM.

If you believe Excel 2016/Office 365 is slower, make sure that:
  • It is a 64-bit installation. Check File...Account...About Excel to find out
  • You only have one core active. The File...Options...Advanced menu item allows you to specify the number of cores that Excel can use in the Formulas group (about 70% down the tab). Let it use all that you have by choosing the option for "Use all processors on this computer"

If you joined Office Insiders to get features like dynamic arrays and XLOOKUP, you should be aware that the code used in Office Insiders versions often contains test features that compare the timings and results of two different ways of doing something. When the fast lookup feature was first announced, I immediately tested it and found...no improvement. I learned some months later that the apparent lack of improvement was because Excel was doing the calcs both the old and the new way. Once Microsoft felt confident that there weren't any problems, they removed the test code and my Office Insiders install now showed the speed improvement that Microsoft had been promising.
PhilPresident

Author

Commented:
I disabled Hardware Graphics Acceleration in the Advanced Display section and that seems to have made it much better.  Thank you so much for all your assistance; you have been most helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial