Microsoft office home and business 2016 Version problem

2023-08-11T02:55:28.07+00:00

Why use the same office2016 installation program will appear different versions, the version installed some time ago odbc database will display 32bit, VBA program can be used normally.

However, after installing different versions during this period, the odbc database will display invalid (N/A), resulting in the VBA program cannot be used.

Can I choose the installation version?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,346 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,359 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,011 Reputation points Microsoft External Staff
    2023-08-11T08:05:17.79+00:00

    Hi,

    You can choose the 32-bit version or 64-bit version of Office to install.

    How did you install Office 2016?

    If you use Office Deployment Tool to install Office 2016, you can change OfficeClientEdition="32" or OfficeClientEdition="64" to confirm if you need to install 32-bit or 64-bit version Office.

    https://learn.microsoft.com/en-us/deployoffice/overview-office-deployment-tool

    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.