DataSheet tab missing in Excel when a datasheet is created using Data Manager


Applies To 
Product(s):AutoPLANT Modeler
Version(s):SS5 | SS6 | SS7 | SS8
Environment: Windows 7/8.1/10 (64 bit)
Area: Data Manager
Subarea: DataSheets
Original Author:Swapnil Joshi, Bentley Product Advantage Group

DataSheets tab missing in Excel when a datasheet is created using Data Manager

Background

The user wants the Datasheets tab to be present in the generated datasheet. This option must by default be present when the isometric is generated. 

This occurs because APExcelAddin is not installed while installing AutoPLANT Modeler in the machine because of permissions issue.

Steps to resolve

  1. Open Windows Explorer.



  2. Navigate to the path C:\Program Files (x86)\Common Files\Bentley Shared\Plant V8i.



  3. Double click on ApExcelAddIn.vsto file to install it.



  4. Now, if we generate a new Datasheet the required tab will be available.

See Also

communities.bentley.com/.../datasheets