This Technical Bulletin describes the process of locking Bentley Datasheets cells to prevent them from being manually updated via Microsoft Excel.
This will configure the Bentley Datasheets so that they can only be updated from the database.• Click on cell to lock. For example _manufactr.• From the Excel pull-down menu select Data > Validation.• Set Allow to List and remove the check from In-cell dropdown. Then hit source button.• Click on any cell on the sheet off the CurrentData range.
• Click the Data Validation button.• Next click on the Error Alert tab and add your own Title and Error Message.
• Hit OK.• Now when you try to update the Manufacturer field in Excel you will get this warning.
• However the field can be updated from the database.
Product TechNotes and FAQs
Plant TechNotes And FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!