Palisade Knowledge Base

Home → Troubleshooting → StatTools → "This action cannot be performed because the Transition Formula Evaluation option is selected ..."

13.10. "This action cannot be performed because the Transition Formula Evaluation option is selected ..."

Applies to: StatTools 5.x–7.x

When I select Summary Graphs » Scatterplot I get the error message

This action cannot be performed because the Transition Formula Evaluation option is selected for worksheet name in workbook name

The Transition Formula Evaluation option is not a general Excel option, but one that can be set for individual workbooks. To reset that Excel option in this workbook, follow this procedure.

  1. Open the file, if it's not already open. (It doesn't mater whether StatTools is open or not.)

  2. Navigate to the Lotus Compatibility Settings.

    • Excel 2010, 2013, 2016: Click File » Options » Advanced. Scroll to Lotus Compatibility Settings.
    • Excel 2007: Click the round Office button, then Excel Options » Advanced. Scroll to Lotus Compatibility Settings.
    • Excel 2003: Click Tools » Options » Transition and look at the Sheet Options section.

  3. (Excel 2007 and newer) Next to "Lotus Compatibility Settings for", select the worksheet mentioned in the error message.

  4. Remove the check mark at "Transition formula evaluation".

  5. Click OK.

  6. Save the file.

You will now be able to create your scattergram.

Last edited: 2015-10-19

This page was: Helpful | Not Helpful