Sunday, January 28, 2018

Hidden names found

Hidden names found

The Document Inspector found hidden names in your workbook. These names can store hidden information about Solver scenarios. For example, when you use the Solver add-in to run a scenario, it may store information about calculation parameters and other sensitive data as hidden names in your workbook.

Issue

The Document Inspector can't remove these hidden names for you.

Recommended solution

You need to run a macro to remove hidden names. For more information, see Macro to Remove Hidden Names in Active Workbook.

Note: If you use this macro to remove hidden names, add-ins (such as Solver) or macros may not work as expected and might lose hidden data associated with them. This macro also affects any defined name that's hidden, not only those that were added by Solver.

No comments:

Post a Comment