What feature allows you to reset a workbook to its initial state, keeping hidden worksheets until drilled into?

The feature that allows you to reset a workbook to its initial state while keeping hidden worksheets until drilled into is the action button. Action buttons in a workbook are interactive components that can execute specific commands or trigger certain behaviors when clicked.

In this context, using an action button helps streamline user interactions by providing a straightforward means to revert the workbook to its starting configuration. This capability is essential in scenarios where data needs to be presented or analyzed in various ways without losing its original context, enabling users to explore additional details in a user-friendly manner.

The other options do not serve this specific purpose. A macro could allow for complex automation and customization but would typically require additional scripting and not have the same straightforward usability as an action button for resetting a workbook. Filters help in managing and viewing specific data but do not restore the workbook to its initial state. Likewise, a pivot table focuses on summarizing data and does not facilitate the resetting of a workbook's state. Therefore, the action button is the best choice for the described functionality.