Edit Microsoft Excel security settings for data sheets and data lists - Integration - Update 44 - Help - Hexagon

Integration Help

Language
English
Product
Integration
Search by Category
Help
Smart 3D Version
12.1 (2019)
Smart Construction Version
2019(7.0)
SmartPlant Foundation / SDx Version
10
Smart Electrical Version
2019 (9.0)
Smart Materials/Smart Reference Data Version
2020 (10.0)
Smart P&ID Version
9 (2019)
Smart Review Version
2020 (15.0)
Smart Engineering Manager Version
10 (2019)
Smart Interop Publisher Version
13.1 (2019 R1)
Smart Isometrics Version
7.0(2019)
Spoolgen Version
9.0(2019)

Excel macros control the edit session in SmartPlant Foundation data sheets and data lists.

  1. Open the data sheet or data list in Microsoft Excel.

  2. Click Options on the Security Warning message bar.

  3. Ensure that the File Path is the location where your Excel files or templates are stored.

    • If you are generating instrument data sheets or instrument indexes, the path is ...\Local Settings\Temp\SPFDatasheet.

    • If you are generating equipment data sheets, the Excel files are in the Enhanced Data Sheets folder.

  4. Select Enable this content.