2. Support
  3. AR# 22922: XPower Estimator (XPE) - I cannot change certain values (device or package type) in the spreadsheet

AR# 22922

XPower Estimator (XPE) - I cannot change certain values (device or package type) in the spreadsheet

Description

I am not able to change some of the pull-down menus in the spreadsheet such as device or package type. What macro security level setting do I need for the spreadsheet functions to work properly?

Solution

For XPE versions 10.X and olderversions, the procedure to edit XPE spreadsheets is as follows:

  1. Open the spreadsheet.
  2. Adialog box asks what should be done with macros, select Enable Macros.
  3. The macro security level must be set to "low" or "medium".
  4. In Excel, select Tools -> Macro -> Security from the main menu.
  5. Close the spreadsheet and re-open it for the macro security settings to take effect.

For XPE versions 11.X andlaterversions,the procedure to edit XPE spreadsheets is as follows:

  1. Open the spreadsheet andlocate the "Options" button at thetop of the spreadsheet.
  2. Click on theOptions button.
  3. Select Enable this content.
  4. Click OK.
AR# 22922
Date 12/15/2012
Status Active
Type General Article
Tools More Less