Way to update one excel and 250 other update from that one

%3CLINGO-SUB%20id%3D%22lingo-sub-2224661%22%20slang%3D%22en-US%22%3EWay%20to%20update%20one%20excel%20and%20250%20other%20update%20from%20that%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224661%22%20slang%3D%22en-US%22%3EHi%20to%20everyone%3CBR%20%2F%3EI%20have%20250%20external%20partners%20to%20send%20them%20different%20excel%20files%20two%20times%20per%20month%2C%20its%20a%20lot%20of%20job%20and%20i%20want%20a%20way%20to%20give%20then%20the%20same%20information%20with%20less%20work%2C%20is%20there%20a%20way%20to%20do%20it%20easier%3F%20Each%20file%20has%20a%20sheet%20with%20two%20pivot's%20with%20the%20number%20of%20the%20job's%20they%20done%20and%20the%20money%20they%20earn%20and%20i%20have%20a%20second%20sheet%20with%20raw%20data%20of%20the%20pivot%2C%20is%20there%20a%20way%20to%20update%20one%20excel%20and%20the%20other%20250%20update%20from%20that%20one%3B%20any%20other%20ideas%3F%20The%20excel%20file%20are%20in%20my%20one%20drive%20and%20they%20will%20see%20them%20online%20or%20in%20there%20mobile%20phones%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2224661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2225365%22%20slang%3D%22de-DE%22%3ESubject%3A%20Way%20to%20update%20one%20excel%20and%20250%20other%20update%20from%20that%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225365%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921034%22%20target%3D%22_blank%22%3E%40skourtisp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20some%20information%2C%20I'm%20almost%20sure%20that%20there%20could%20also%20be%20ready-made%20solutions.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20just%20have%20to%20search%20the%20endless%20expanse%20of%20the%20Internet.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20it%20could%20be%20made%20to%20order.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20you%20allow%20Excel%20for%20web%2C%20you%20will%20have%20to%20accept%20a%20number%20of%20restrictions.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ERecommend%20you%20to%20get%20an%20O365%20version.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMany%20possibilities%20with%20little%20money%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-external-data-in-a-workbook-in-the-browser-3e51741e-a9bf-4577-8342-7c07ae23dbbd%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ERefresh%20external%20data%20in%20a%20workbook%20in%20the%20browser%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi to everyone
I have 250 external partners to send them different excel files two times per month, its a lot of job and i want a way to give then the same information with less work, is there a way to do it easier? Each file has a sheet with two pivot's with the number of the job's they done and the money they earn and i have a second sheet with raw data of the pivot, is there a way to update one excel and the other 250 update from that one; any other ideas? The excel file are in my one drive and they will see them online or in there mobile phones
1 Reply

@skourtisp 

Here is some information, I'm almost sure that there could also be ready-made solutions.

You just have to search the endless expanse of the Internet.

Or it could be made to order.

If you allow Excel for web, you will have to accept a number of restrictions.

Recommend you to get an O365 version.

Many possibilities with little money

 

Refresh external data in a workbook in the browser

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)