Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Trouble-Shooting Office Integration
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • +ProjectWise Client
      • +Featured Articles - Projectwise Explorer
      • +Audit Trail - ProjectWise Explorer Client
      • +Bentley IMS Login
      • +BS1192 Rules Engine - ProjectWise Explorer Client
      • +Check In Dialog - ProjectWise Explorer Client
      • +Document Code - ProjectWise Explorer Client
      • +Document Creation - ProjectWise Explorer Client
      • +Documentation & Help - ProjectWise Explorer Client
      • +Environments and Attributes - PWE
      • +Export / Import Tool - ProjectWise Explorer Client
      • +Folders / Subfolders - ProjectWise Explorer Client
      • +GUI - ProjectWise Explorer Client
      • +Installation - ProjectWise Explorer Client
      • +Integration - General
      • +Integration - AutoCAD - ProjectWise Explorer Client
      • +Integration - Civil 3D - ProjectWise Explorer Client
      • +Integration - DGN Platform - ProjectWise Explorer Client
      • +Integration - MicroStation - ProjectWise Explorer Client
      • -Integration - Office - ProjectWise Explorer Client
        • Opening a Second or Third Excel .XLS (old format) in ProjectWise
        • Error found in Custom UI XML of "ProjectWise iDesktop Integration"
        • Adding ProjectWise path and folder name to Office file footer
        • Blank Word document or Excel Sheet opens with ProjectWise Office Integration
        • Microsoft Excel cannot access the file ':: ODMA\.....filename.xlsx.
        • ProjectWise Attribute Exchange with Microsoft Word [TN]
        • Trouble-Shooting Office Integration
        • Unable to open two Word Documents at a time.
        • Unable to save to disk when doing a save as when integrated with ProjectWise
        • Word or Excel opens as a blank document or error 50002 or 112173
        • Microsoft Office 2010 prerequisites are missing
        • Cannot start application for the specified document Check your program associations
        • Opening excel spreadsheet from ProjectWise, getting book1 and intended file
      • +Integration - Revit - ProjectWise Explorer Client
      • +Logs Troubleshooting- ProjectWise Explorer Client
      • +Messaging Service - ProjectWise Explorer Client
      • +MISC - ProjectWise Explorer Client
      • +Open / Save / Copy / Move - ProjectWise Explorer Client
      • +Photo Preview - ProjectWise Explorer Client
      • +ProjectWise Managed Workspaces
      • +Project - ProjectWise Explorer Client
      • +Search - ProjectWise Explorer Client
      • +Security and Permissions - ProjectWise Explorer Client
      • +User Tools - ProjectWise Explorer Client
      • +Views - ProjectWise Explorer Client
      • +Workflows & States - ProjectWise Explorer Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

     
     Questions about this article, topic, or product? Click here. 

    Trouble-Shooting Office Integration

    Office Integration issues are a challenge to resolve. This post is written as a progression to help you step through the workflow to resolve these issues. Test each step before moving to the next one.

    This post is written using Word as the example and applies to all the Office Integrated apps, such as Excel.

    Note: This is a living document if you discover something that resolves your issue and it isn't in this document, please add it.

    Opening a Second or Third .XLS (old format) in ProjectWise

           When opening an Excel .xls (old format) in ProjectWise, you cannot open another “second or third” .xls. No Error message is given. However, you may open a .xlsx, and then open 6 or 7 other .xlsx other ProjectWise integrated Excel spreadsheets. This is a known issue.   You may also open a .xls, then open 6 or 7 .xlsx files in ProjectWise.

    Note: ProjectWise Explorer Client 10.00.03.167 allows multiple Excel files to be opened without regard to version.

    Is Office Up to Date?

    Before trouble shooting make sure that all the Office updates are installed.

    Is the problem isolated to one user, or is it more widespread?

    If the problem is isolated to one user, it may be a problem with their Windows profile. A valid troubleshooting step is to have a different user login on the same machine and attempt to use ProjectWise with office integration. If it works using a different user's login to windows (different profile). The problem is likely with the original user's windows profile. If the problem occurs on several machines, you should proceed under the impression that it may be a version compatibility issue, a software environment issue, or a security issue.

    Is Office Integration installed?

    Depending on the version of ProjectWise Explorer Client (PWE) that was installed, the office integration may need a separate install module or a new installation.

    To check for Office integration:

    • Open Word from the desktop.
    • Select the blank template.
    • Select the ProjectWise ribbon.

    If there is no ProjectWise Ribbon, there is no integration. If integration is missing you will need to install it.

    Install Integration:

    • For ProjectWise Explorer V8i - 8.11.11.xx install the appropriate Office Integration Module version add-in.
    • For ProjectWise Explorer CE – 10.00.0x-xx Uninstall ProjectWise Explorer and remove any residual files, then reinstall the latest release of ProjectWise Explorer CE – 10.00.02.xx or higher.
    • Do a custom install and enable Office integration.
    • Launch Word, then select File Open and the ProjectWise login dialog will display.

    If the ProjectWise ribbon is present in the ribbon bar, but the ProjectWise variable dialog doesn’t display, then integration may not be fully installed.

    Reinstall Integration:

    • Uninstall ProjectWise and remove any residual files.
    • Use a registry cleaner of your choice
    • Repair the Office Installation from Programs and Features.
    • The best option is to then install the latest release of ProjectWise Explorer CE – 10.00.02.xx or higher. It will deliver the latest integration available for Office.
    • Open Word and select File Open. The ProjectWise login dialog will display.

    At this point if the PWE login dialog doesn’t open (integration isn’t working) open a Service Request.

    ProjectWise Application Associations

    When an office document doesn’t open from PWE the first thing to check is the ProjectWise application association.

    ProjectWise application associations can be set Globally or for a User.

    Global ProjectWise associations:  Global Associations are set-up by an Administrator using the ProjectWise Administrator client.  To setup Global associations, Install the ProjectWise Administrator on a system that has all the programs the client will use.  This makes it easier to setup the class paths for the program associations.

    User ProjectWise Associations: Some clients may have the software in a different path and thus will need a user specific program association. The most common case is when a user from one organization is logging in another organization’s datasource.

    To check the application associations:

    • Open PWE and login to the datasource as the user having the issue
    • Select Tools à Associations à Programs
    • Switch the View to User Associations
    • Look at the Application that is not opening correctly
    • Expand Open.

    If there is a user association, it needs to be removed.

    Removing User Application Associations

    • Follow the steps above to view the user association.
    • Right Click on the Open path and Un-associate it.
    • Close the dialog and open a file from ProjectWise.

    If the file opens correctly the user association was the problem.

    If the file still doesn’t open correctly, then try creating a new user association.

    Creating a User Application Association

    • Select Tools à Associations à Programs
    • Change the drop down menu in All Associations (Global and User) to User Associations.
    • Select the Application that matches what the file is using.
    • Right-click on Open and select Add Association
    • Select ProjectWise-integrated Microsoft Word, notice the program group is Word.Document.PW. (This program group was created by the installer.) Select OK to use this program for the association.

    NOTE: If the program group is not found you will need to follow the reinstall instruction above.

    • Now open a file from ProjectWise.

    If the file opens correctly the global association was the problem.

    Use command-line switch for the MS Excel app

    Hold Shift key while opening an Excel file from the ProjectWise Explorer. In case this works add "/x" to the following Registry key:

    HKEY_CLASSES_ROOT\Excel.Sheet.PW.16\shell\Open\command

    C:\Program Files\Microsoft Office\root\Office16\excel.exe /x

    COM Objects

    If changing the application associations doesn’t resolve the issue it may be that the Com object is unloading.

    To Check the ProjectWise com objects:

    • Open Word.
    • Select File àOptionsàAdd-ins

    Look in the Add-ins Dialog for the ProjectWise Com Objects.

    1. If the ProjectWise com objects are disabled continue to the next step.
    2. If the ProjectWise com objects are enabled and Word is still opening to a blank file jump to the final section of this document.
    3. If the ProjectWise com objects are missing, go to the first section on reinstallation.

    There are several reasons why ProjectWise integration add-ins could be disabled; including:

    • The Bentley add-in(s) are not trusted
    • Disabled by Office as a precaution
    • Disabled as a policy

    If the add-in has been disabled by Office as a precaution you may need to re-enable the appropriate add-in. But before you do that, make sure that the Bentley add-ins are trusted.

    Trust Relationships

    Checking that Bentley is trusted:

    • Open Word.
    • Select File àOptionsà Trust Center
      • Select Trust Center Settings
      • Select Trusted Locations
      • Look for the following folders in the Trusted Location Dialog:
        • C:\Program Files\Bentley
        • C:\Program Files (x86)\Bentley
        • C:\Program Data\Bentley
        • C:\WorkingDir (This should be the root folder you use for the Work Dirs)

    If the folders are not there then they need to be added. The paths listed may vary depending on your configuration.

    Setting Bentley Folders as trusted:

    • Select Add New Location
    • Browse to: C:\Program Files\Bentley
    • Check on the Subfolders of this location are also trusted
    • And select OK
    • Repeat this for:
      • C:\Program Files (x86)\Bentley
      • C:\Program Data\Bentley
      • C:\WorkingDir (This should be the root folder you use for the Work Dirs)
      • Exit the Trust Center and open a file.

    If Word stops on the blank file again check if the ProjectWise com objects are disabled. If they are then manually re-enable the com objects.

    Disabled Com Objects

    Manually enabling the com objects.

    • Open Word.
    • Select File àOptionsà Add-Ins page
      • Select ‘Go’ next to Manage COM Add-ins
      • Select the check box next to “ProjectWise iDesktop Integration” to enable it
      • Exit the trust center.
      • Close and reopen Word

    If this selection doesn’t “stick” the next thing to try is to disable the Resiliency registry key.

    NOTE: It is highly recommended to use this method as a last resort since removing the disabling of registry keys can have adverse effects on application stability and security.

    Please check with your system administrator or IT department for proper direction before changing any registry keys.

    Removing the disabling of the com objects in the registry.

    • Use Regedit and find the affected Office product add-in:
      Key: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Resiliency\DisabledItem
      • Your computer may show several office versions. You are looking for the version that corresponds with the Office you are running. 12.0 in the above example.
      • Right click on Disabled items
      • Select Export to back up the key to a safe location.
      • Then delete the keys below disabled items.
      • Exit regedit and Open a file with Word.

    The file should now open directly in Office. If you are still getting the blank first page and you are using ProjectWise Explorer V8i - 8.11.11.xx open a Service Request.

    If you are using ProjectWise Explorer CE – 10.00.0x-xx the CURVER registry key may need to be edited.

    Enabled COM Objects in Office 365

    The Attribute Exchange options are grayed out under the ProjectWise tab.
    Both Com Objects ProjectWise iDestop integration and ProjectWise iDestop integration for Attribute Exchange are selected.

    There was another Com Object listed, PWAdminOfficeConnectProxy.

    Try deleting the PWAdminOfficeConnectProxy add-in from the Coms Add-ins dialog. 

    Incorrect Version Reg Keys

    Deleting legacy registry key

    • Use Regedit and find the affected Office product add-in:
      HKEY.CLASSES.ROOT.\Word.Document.PW
      • Right click on Word.Document.PW
      • Select Export to back up the key to a safe location.
      • Then delete the curver keys below Word.Document.PW.
      • Exit regedit and Open a file with Word.
      • Repeat as necessary for additional products:
        • HKEY.CLASSES.ROOT.\Excel.Sheet.PW
        • HKEY.CLASSES.ROOT.\MsProject.Project.PW

    Load Behavior

       When opening Word in ProjectWise, it does not open in Integrated fashion. Can check to see if Load Behavior is set properly in the registry.  

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Word\Addins\PWOfficeAddIn.ConnectProxy_15       Load behavior should have a value of "3" (ConnectProxy_15 is for office 2013  ConnectProxy_16 is for Office 2016)  If using Office 2016, sometimes removing ConnectProxy_15 for Office 2013 will improve the integration with Office 2016.

    Is ProjectWise getting a valid license:

    A user reported an issue where they double clicked an office file in ProjectWise, the file copied out but then he would get Error 50002: Cant start application for specified document.... 

    ProjectWise requires a valid license and a connection to the SelectServer to report usage.  If the SelectServer has not reported usage, and or the ProjectWise integration server had not been able to report usage to the SelectServer and is running in eval mode, or with X amount of days left to report, or if the client is getting its own license from a SelectServer that is not functioning properly, you may see an issue with Office files hanging during the open process.  Once the user resolved the licensing issue, Office products opened with no issues.

    If this doesn’t resolve the issue open a Service Request

    • Office Integration
    • Application integration
    • ProjectWise Explorer Client
    • Share
    • History
    • More
    • Cancel
    • Vickie Ramsey Created by Bentley Colleague Vickie Ramsey
    • When: Wed, Mar 29 2017 9:00 AM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Fri, Sep 30 2022 1:27 PM
    • Revisions: 16
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies