Linking excel and power point in shared environment

%3CLINGO-SUB%20id%3D%22lingo-sub-2314247%22%20slang%3D%22en-US%22%3ELinking%20excel%20and%20power%20point%20in%20shared%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2314247%22%20slang%3D%22en-US%22%3EI%20need%20some%20advice%20%2F%20guidance%3CBR%20%2F%3ECurrently%20i%20am%20managing%20COVID-19%20Data%20in%20my%20Region%20%2F%20State%20in%20Excel%20and%20Power%20Point%20files.%20I%20receive%20different%20data%20in%20form%20of%20Excel%20tables%20%2F%20Power%20Point%20files%2C%20which%20causes%20lot%20of%20mess%20when%20furnishing%20%22Summary%20%2F%20COVID%20Statistics%20files%22.%3CBR%20%2F%3EIs%20there%20any%20way%20that%20I%20could%20ask%20all%20stakeholders%20to%20provide%20me%20Data%20in%20one%20common%20excel%20file%20or%20Database%2C%20in%20a%20format%20that%20is%20best%20suited%20for%20me.%20I%20want%20to%20restrict%20all%20my%20Data%20Sources%20(I%20receive%20Data%20From%20District%20Management%2C%20Hospitals%20and%20Civil%20authorities%20in%20variety%20of%20formats%20e.g%20excel%20tables%20and%20ppt%20files)%20to%20follow%20one%20common%20format%20and%20not%20accidentally%20make%20mistakes.%3CBR%20%2F%3E%3CBR%20%2F%3EBasically%2C%20what%20i%20need%20is%2C%20One%20large%20file%20or%20ledger%2C%20where%20all%20parties%20can%20put%20their%20Data%20(probably%20on%20Cloud)%20so%20that%20i%20can%20link%20that%20consolidated%20excel%20data%20to%20excel%20charts%20and%20further%20to%20power%20point%20files.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20common%20problem%20that%20i%20face%20is%20when%20someone%20shares%20a%20ppt%20file%20in%20which%20there%20are%20excel%20tables%20%2F%20charts%20linked%2C%20I%20cannot%20update%20them%20due%20to%20%22Broken%20link%22%20error.%20On%20top%20of%20that%2C%20there%20is%20no%20way%20to%20track%20which%20table%20in%20powerpoint%20is%20connected%20%2F%20linked%20to%20which%20excel%20file%20(usually%20one%20ppt%20file%20is%20comprised%20of%20my%20tables%20and%20charts%20which%20are%20further%20linked%20to%20several%20excel%20files).%3CBR%20%2F%3ENeed%20your%20kind%20help%20as%20COVID%20Data%20is%20growing%20day%20by%20day.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2314247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2314376%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20excel%20and%20power%20point%20in%20shared%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2314376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042729%22%20target%3D%22_blank%22%3E%40saddi2u%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20find%20it%20surprising%2C%20in%20all%20candor%2C%20that%20you're%20asking%20this%20question%20%3CU%3E%3CEM%3E%3CSTRONG%3Enow%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E%2C%20on%20May%201%20of%202021.%20Covid%20is%20not%20new%2C%20nor%20is%20the%20data%20gathering%20process.%20One%20of%20the%20first%20things%20I%20helped%20another%20user%20with%20on%20this%20site%2C%20%3CU%3Ewell%20over%20a%20year%20ago%20now%3C%2FU%3E%2C%20had%20to%20do%20with%20tracking%20data%20on%20Covid-related%20work%20being%20done%20by%20fire%20fighters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20I%20would%20in%20your%20place%20be%20asking%20how%20your%20counterparts%20in%20other%20states%20and%20regions%20have%20solved%20the%20same%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I%20certainly%20wouldn't%20be%20using%20Power%20Point%20in%20any%20way%20in%20the%20data%20gathering%20phase%20of%20things%3B%20maybe%20in%20reporting%2C%20but%20that's%20a%20total%20misuse%20of%20Power%20Point.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20considered%20creating%20a%20standard%20form%20in%20in%20Google%20Sheets%20for%20those%20who%20submit%20data%20to%20you%3F%20That%20would%20be%20one%20way%20to%20standardize%2C%20and%20have%20multiple%20users%20entering%20in%20the%20same%20place....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20don't%20have%20an%20easy%20task%2C%20for%20sure........%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20desire%20more%20help%2C%20might%20I%20suggest%20you%20post%20some%20sample%20sheets%20that%20show%20what%20all%20the%20data%20is%20that%20you%20need%2C%20and%20how%20it's%20formatted%20now%2C%20how%20you'd%20like%20it%2C%20etc....%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I need some advice / guidance
Currently i am managing COVID-19 Data in my Region / State in Excel and Power Point files. I receive different data in form of Excel tables / Power Point files, which causes lot of mess when furnishing "Summary / COVID Statistics files".
Is there any way that I could ask all stakeholders to provide me Data in one common excel file or Database, in a format that is best suited for me. I want to restrict all my Data Sources (I receive Data From District Management, Hospitals and Civil authorities in variety of formats e.g excel tables and ppt files) to follow one common format and not accidentally make mistakes.

Basically, what i need is, One large file or ledger, where all parties can put their Data (probably on Cloud) so that i can link that consolidated excel data to excel charts and further to power point files.

A common problem that i face is when someone shares a ppt file in which there are excel tables / charts linked, I cannot update them due to "Broken link" error. On top of that, there is no way to track which table in powerpoint is connected / linked to which excel file (usually one ppt file is comprised of my tables and charts which are further linked to several excel files).
Need your kind help as COVID Data is growing day by day.
1 Reply

@saddi2u 

 

I find it surprising, in all candor, that you're asking this question now, on May 1 of 2021. Covid is not new, nor is the data gathering process. One of the first things I helped another user with on this site, well over a year ago now, had to do with tracking data on Covid-related work being done by fire fighters.

 

Anyway, I would in your place be asking how your counterparts in other states and regions have solved the same problem.

 

And I certainly wouldn't be using Power Point in any way in the data gathering phase of things; maybe in reporting, but that's a total misuse of Power Point.

 

Have you considered creating a standard form in in Google Sheets for those who submit data to you? That would be one way to standardize, and have multiple users entering in the same place....

 

You don't have an easy task, for sure........

 

If you desire more help, might I suggest you post some sample sheets that show what all the data is that you need, and how it's formatted now, how you'd like it, etc....