Clicking/editing powerpoint to automatically update excel

[PPteacher]

Hi all,

I've been looking for some time for an answer to this. All I have found so far is the possibility of updating information in excel (information for charts/graphs etc) and being able to transfer it over to the same chart/graph embedded into powerpoint automatically - what I am looking for is the opposite.

I have a document that I have used for some time in my educational setting. This is an excel document where teachers have to input figures and everything around it updates to show the progress and necessary figures for the pupils.

I have recently set up a document with many different challenges that link with the objectives in the excel document. I would like the powerpoint to be pupil led, ideally without them being able to access the excel document (incase they edit the document or delete information from this - it is an important document).



What I would like is that, either by clicking a hyperlink, a button, entering a digit or progressing to a certain point within the powerpoint (or any other suggestion), the powerpoint will automatically updates the figures in the excel document.

I'm not sure this is possible as I've searched far and wide for the solution and it does seem a bit specific. Even if it could update/change an element of the particular excel document, then I could try and use certain formulas for this to then update the figure within the same document.

Any help/alternative advice would be appreciated.

Thanks,

A new user!