Update: New upgrade readiness tools for Office 365 ProPlus

Microsoft

Update: The the Readiness Toolkit for Office add-ins and VBA is now available for download. Read more about it on our new post and download the toolkit and start using it today.

 

We are excited to announce new tools to support the application compatibility readiness for Office 365 ProPlus. Over the next year, we will roll out tools to catalogue your organization’s add-ins, assess the status of VBA applications and deliver an improved support for 64-bit VBA. Customers tell us about the importance of application compatibility in their ProPlus upgrade plans and these tools make planning and execution easier. We are releasing them in limited preview now. Reach out to us at ReadyForOffice@microsoft.com to be part of the preview program.


The new tools we are creating for application compatibility include:

  • Updates to the Office Telemetry Dashboard
  • New tools for add-in readiness reporting
  • 64-bit common control support
  • Office add-in reporting in Windows Upgrade Analytics


In addition to supporting internal add-ins and VBA applications, we are adding more readiness information for Office add-ins from 3rd party ISVs. Later this year, we will publish a searchable list of ISVs who already support Office 365 ProPlus and we’ll start the validation of those popular 3rd party add-ins in the new Office builds, giving you the confidence that your solutions will continue to work with the latest versions of Office. 


Office Telemetry Dashboard


The Office Telemetry Dashboard is an existing solution that helps you to gather inventory and usage information about add-ins used within your organization.  We are now extending the Office Telemetry Dashboard to include readiness information.


There are three key pieces of readiness information that this tool provides:

  • ProPlus Ready 32 Bit. The add-in is widely adopted and used by enterprise customers in ProPlus and there are no known problems with the add-in
  • ProPlus Ready 64 Bit. A 64-bit version of the add-in is available and widely adopted by enterprise customers in ProPlus and there are no known problems with the add-in
  • ISV Support. The ISV has committed to support the add-in on ProPlus.


This information helps you better plan an upgrade by knowing how many of the add-ins are expected to work seamlessly with ProPlus and how widely add-ins with potential issues are used within your organization and in which specific departments.
Example of readiness reports include the following:

 

Office 365 ProPlus readiness for add-insImages 1.png

 

 

 Detailed view of Office 365 ProPlus readiness for add-insImage 2.png

 

VBA Macro Readiness
For enterprises that rely on macro-enabled Office documents to perform business critical tasks, we are pleased to announce the new VBA Readiness Tool. This tool is designed to help your organization identify the most commonly used documents and determine if you are likely to encounter any compatibility issues.


Compatibility issues are rare for most enterprises. The VBA Readiness Tool provides a report to quantify these issues for your enterprise.

 

How it Works
The VBA Readiness Tool works by scanning each PC to gather an inventory of the most recently used documents that contain VBA code. Documents that include VBA code, will be analyzed against a list of all known compatibility issues to determine if you are likely to encounter issues with the file after upgrading to ProPlus.


The detailed report gives you all the information and confidence you need to plan your upgrade and to remedy any combability issues.image 3.png

 


64-bit COM Controls

Many Office users rely on the power of macros and forms to get tasks done. Some of these macros use Common Controls to create user interfaces or other such functions for users. Today, these Common Controls only work with the 32-bit version of Office.

 

We're working to ensure a great experience on 64-bit Office and we will be releasing an update to our ProPlus client which brings 64-bit support to the Common Controls.


The following nine controls will be included in the update:image 4.png


Once this update is rolled out later this year, taking advantage of 64-bit Common Controls will be seamless for users, with existing solutions continuing to work as they do today (though you may separately need to update your use of things like Declare statements, which you can read more about on MSDN).

 

We are excited to bring 64-bit support to the Common Controls for Office ProPlus. We look forward to hearing your feedback.


Office add-in report available in Windows Upgrade Analytics
We announced the general availability of Upgrade Analytics in February 2017. Upgrade Analytics is a free tool helping organizations move to Windows 10. Learn more at http://technet.microsoft.com/itpro/windows/deploy/upgrade-readiness-get-started


This tool also provides an inventory of Office add-in used within your organization.image 5.png

 

 

If your organization is planning a combined Windows 10 and Office ProPlus rollout, this tool is a one-stop shop to access both Windows application and Office add-in readiness.

 

Pilot Program
While all the tools listed in this blog are releasing later in 2017, we are accepting a limited number of enterprises into a pilot program. If you’d like to participate in this pilot program and are willing to share feedback with Microsoft, please let us know at ReadyForOffice@microsoft.com.

7 Replies

We're planning to upgrade from Microsoft Office 2013 Professional Plus (32-Bit) to Office 365 ProPlus (64-Bit) on Windows 10. We see more issues relying on the ODBC/OleDB database connections used in MS Access and MS Excel.

I'm wondering, if these database connections will be reported, too? Especially, when they're using the Jet Engine (32-Bit) which doesn't exist for 64-Bit.

I have the same question for version dependant addins which are delivered by Microsoft itself? I.E. solver.xlam is referenced either in folder 'Microsoft Office\Office15\Library' or in folder 'Microsoft Office\Office16\Library'. Is there a way to automatically change the reference to that version, which is installed? Otherwise an Workbook which has been upgraded won't work on the older version anymore. And for the migration time we have teams working with the same workbook/database files on different versions of Office.

Did 64-bit Common Control support go in?  I thought I saw it sneek in, in Version 1707 (Build 8326.2087) but have not seen word in the ProPlus CTR release notes that it ever made it into the 1708 roll-up release to the Semi Annual (Targeted).  Please do advise.  Thanks!

We're seeing more push for 64-bit Excel.

Is there an update on the progress being made to get 64-bit COM support into 64-bit Office ProPlus?

 @Daniel Canning  @Kim Kischel?

@Steve Conn Can someone on your team provide any insight on the progress with regards to Duncan's question?

Hi Kim--

 

Yes, indeed!  1707 included 64-bit support for the MSCOMCTL.ocx.

https://technet.microsoft.com/en-us/office/mt465751

Current Channel

July 27, 2017
Version 1707 (Build 8326.2058)

 Office suite: Non-security updates

This channel release contains the following non-security updates:

  • Add 64-bit support for mscomctl.ocx, allowing users working in 64-bit versions of Office to create, edit, and open macro files containing the Common Controls.

Thanks Steve. I was looking for that but somehow completely missed it. Released with little fanfare then? ;) 

Hi

 

I currently have data in Upgrade Analytics and regarding the Office Plugins, i am being asked to provide details of  which plugins are 32bit and which are 64bit. I have 374 unique addins over 34k devices for which we need to assess an upgrade from 32bit to 64bit.

 

Is this possible ato determine which are 32bit or 64bit?

 

Thanks

Chris