Share via

Excel Weeekly Meal Planner Template

Anonymous
2021-07-23T16:15:44+00:00

Weekly meal planner template in Excel and available on MS office website is an awesome template. However it only aggregates ingredients into shopping list from 4 recipes. I have tried several things to add additional recipes but the ingredients in these recipes do not go to the shopping list. Do you know how to update the existing template to include additional recipes - so the ingredients aggregate on the shopping list tab? Thank you for your help!

Microsoft 365 and Office | Excel | For business | 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
Answer accepted by question author
  1. Anonymous
    2021-07-28T10:20:35+00:00

    Hi Kathleen,

    Sorry for my late reply.

    According to your description, when you add a new recipe (sheet), the ingredients of the new recipe won’t be added in the SharePoint list. To display the ingredients of the new recipe, please try the following steps:

    1. To create a new recipe, you can create a copy of Empty Recipe, then type the ingredients you need in the new recipe
    2. Go to Recipe Index, type the name of the new recipe in column B. The template will insert other information of the new recipe automatically.
    3. Go to Meal Planner, select the new recipe for one weekday. After that, when you go back to Shopping List, you will see the ingredients of the new recipe.

    If you have any updates, please feel free and come back to share with us.

    Regards,

    George

    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-25T19:12:04+00:00

    Hi George,

    I was able to get this excel template to compile ingredients for a total of 7 recipes. However, it will not build ingredients for more than 7 total recipes. Is this something you can fix or update formula (I think in the meal planner tab) to allow for more recipes.
    Thanks for your help, Kathleen

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-08-04T17:36:01+00:00

    Thank you for responding but the ingredients do not add to the Sharepoint  shopping list for more than 4 recipes.   Are you able to update the template to add unlimited amount of recipes?   Please let me know.  Thanks, Kathleen

    1 person found this answer helpful.
    0 comments