Linking Excel Data to Powerpoint

  • Hello
    I'm having difficulty linking excel charts and tables into powerpoint.

    I use the copy and link paste but I have to click on each chart in excel to update it.
    Also, I cannot seem to link a table.

    Does anyone know how I can automatically update PP when it is opened so that all charts update simultaneously?
    Also, how do you link a table?

    Help very much appreciated