Installing The Power Query Add In For Excel 2010/2013, How To Determine Whether You Have 32

*

The new version of Office, Office 2010 (Office twenty-ten) will be available in both a 32 bit and a 64 bit version. All previous version of Office were 32 bit. Office 2010 will be released in the first half of 2010.

Đang xem: Installing the power query add in for excel 2010/2013

At this moment our advise is to install the 32 bit version of Office, even if you have a 64 bit OS. In this post I give you a few reasons why we think it is in most cases the best solution. Until there is proof of great benefits, the 32 bit version seems to be the best for compatibility and you don”t seem to anything significant.

Xem thêm: khóa học marketing manager

First, according to Microsoft: “64-bit Excel, simply put, is for building really really (really) big workbooks.”

There a few things to keep in mind before you choose to install the 64 bit version of Office 2010:

Most add-ins don”t support the 64 bit version of Excel 2010At this moment ASAP Utilities does not work with the 64 bit version of Excel 2010, it only works with the 32 bit versions of Excel. In order to support the 64 bit version of Excel 2010 we have to create a special 64 bit version for it. However, the current tool we use from MS doesn”t support that (MS Office Developer edition). Furthermore, at this moment Office is still a beta version from which MS hasn”t released all the details yet, which makes the development of a 64 bit version uncertain. Besides we do need to use another program for the development of ASAP Utilities, which will probably be Visual Studio 2010, but that isn”t released yet either. They way I see it at this moment is that it might perhaps be wise to see how many people will actually use the 64 bit version of Excel and then we can see if we can justify the extra time and money we need to put into the development of a special 64 bit version and maintaining both a standard 32 bit and a 64 bit version.The only major advantage of the 64 bit version at this moment seems to be that it can handle Excel files larger than 2 GB (2 Gigabyte!).

Xem thêm: Khóa Học Quản Trị Doanh Nghiệp Vừa Và Nhỏ Tốt Nhất 2021, Khóa H&#7885C Qu&#7843N Lý Doanh Nghi&#7879P

Interesting source to read:

MS Office 2010 forums http://social.technet.microsoft.com/Forums/en-US/office2010general/threads

Update on june 7, 2010: Microsoft Technet: 64-bit editions of Office 2010 (Published: May 12, 2010) The recommendations for which edition of Office 2010 to install are as follows:

If users in your organization depend on existing extensions to Office, such as ActiveX controls, third-party add-ins, in-house solutions built on previous versions of Office, or 32-bit versions of programs that interface directly with Office, we recommend that you install 32-bit Office 2010 (the default installation) on computers that are running both 32-bit and 64-bit supported Windows operating systems.
Tweets that mention Excel 2010: Use the 32 or 64 bit edition? 32 Bit might be wiser… | asap utilities / excel blog — Topsy.com December 8, 2009at5:55 am

<…> This post was mentioned on Twitter by James Dutton, Rice Communications. Rice Communications said: RT
insightr: Word of warning from Microsoft: Don't buy 64bit version of Office 2010 or your plugins likely won't work: http://bit.ly/59aSBR <…>

Xem thêm bài viết thuộc chuyên mục: Excel