Can work sheets be nested?

Anonymous
2021-06-14T19:01:26+00:00

I want to do a work book in which I have work sheets that are years ex 2020, 2021. When I select the year tab I's like it to open into another workbook that has quarters listed for work sheets. Is this possible?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-06-18T09:52:30+00:00

    I would suggest a variation of Trip's idea.

    Use either:

    • tables if you need to show detail data, or
    • Pivot Tables if you need to generate summary information and hide detail data

    In either case you can use the Filter feature or Slicers to select the specific years and quarters you want to display.

    Yes, you can use the "show Report filter pages" feature to split out into separate tabs. But, that feature is incomplete. There is no connection between the pivottable and the generated tabs. If you update the date and geneate new tabs, you also have to delete the old ones.

    .

    If you are interested in trying pivottables or tables let us know. I can provide tips to how to articles. And if you supply us with an example file, 2 or 3 years, 2 or 3 quarters, 2or 3 customers, 2 or 3 data rows for each of the levels.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-06-18T09:23:28+00:00

    Hi dougrich13,

    May I know if you still need help? If so, you can post back and we will try our best to help you.

    Best Regards,

    Sukie

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. triptotokyo-5840 36,686 Reputation points Volunteer Moderator
    2021-06-14T19:37:31+00:00

    I want to do a work book in which I have work sheets that are years ex 2020, 2021. When I select the year tab I's like it to open into another workbook that has quarters listed for work sheets. Is this possible?

    1.

    You can (for an existing Pivot Table):-

    Show Report Filter Pages . . .

     - by:-

    PIVOTTABLE TOOLS

    ANALYZE contextual tab

    PivotTable group

    Click on the drop down arrow to the right of:-

    Options

     - then click on:-

    Show Report Filter Pages . . .

    Year

    OK

    2.

    The above would break out a Pivot Table into x number of separate Worksheets for each year (where Year had been set up in the underlying data as a field / column).

    3.

    The above would give you this:-

    I want to do a work book in which I have work sheets that are years ex 2020, 2021.

    Really the above’s, “de-nesting”.

    You nest them first in the Pivot Table and then, “de-nest” them using the:-

    Show Report Filter Pages . . .

     - process.

    Was this answer helpful?

    0 comments