Applies to: StatTools 5.x and Up

Error:

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

Cause and Solution:

The Transition Formula Evaluation option is not a general Excel option, but one that can be set for individual workbooks.

To reset the Excel option in this workbook:

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.

   • Click File » Options » Advanced. Scroll to Lotus Compatibility Settings.

3. 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.