Home

Best Practice: Linking data from e.g. Excel (or sharepoint) into Word report

%3CLINGO-SUB%20id%3D%22lingo-sub-235702%22%20slang%3D%22en-US%22%3EBest%20Practice%3A%20Linking%20data%20from%20e.g.%20Excel%20(or%20sharepoint)%20into%20Word%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-235702%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CSPAN%3EDear%20community%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20want%20to%20create%20a%20report%20template%20for%20my%20work%20where%20I%20can%20simply%20fill%20in%20the%20data%20I%20want%20to%20have%20in%20my%20report%20into%20a%20excel%20sheet%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eand%20then%20it%20gets%20automatically%20inserted%20into%20my%20word%20report%20at%20the%20correct%20place%20and%20with%20the%20correct%20formatting.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20already%20tried%20to%20use%20the%20data%20linking%20between%20excel%20and%20word%20but%20it%20is%20pain%20in%20the%20ass%20(extremly%20long%20loading%20times%20when%20opening%20the%20document%2C%20and%20the%20workaround%20is%20just%20to%20difficult%20for%20the%20whole%20company).%20So%20I%20now%20wanted%20to%20ask%20you%20if%20you%20have%20any%20idea%20how%20such%20a%20thing%20can%20be%20done%20in%20a%20simple%20and%20working%20way.%20We%20also%20use%20a%20microsoft%20sharepoint%20system%20which%20could%20be%20used%20to%20achive%20this%20goal%20or%20to%20provide%20a%20mask%20to%20fill%20in%20the%20data%20for%20the%20report.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20really%20hope%20somebody%20can%20give%20me%20some%20hints%20how%20I%20can%20achive%20this%20goal%20and%20create%20a%20generic%20report%2C%20where%20only%20customer%20data%20and%20all%20other%20individual%20data%20can%20be%20inserted%20by%20just%20typing%20the%20data%20in%20the%20correct%20excel%20cell%20or%20something%20like%20this.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20very%20much%20in%20advance.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EMax%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-235702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWord%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
null null
New Contributor

 Dear community,

I want to create a report template for my work where I can simply fill in the data I want to have in my report into a excel sheet
and then it gets automatically inserted into my word report at the correct place and with the correct formatting.

I already tried to use the data linking between excel and word but it is pain in the ass (extremly long loading times when opening the document, and the workaround is just to difficult for the whole company). So I now wanted to ask you if you have any idea how such a thing can be done in a simple and working way. We also use a microsoft sharepoint system which could be used to achive this goal or to provide a mask to fill in the data for the report.

I really hope somebody can give me some hints how I can achive this goal and create a generic report, where only customer data and all other individual data can be inserted by just typing the data in the correct excel cell or something like this.

Thank you very much in advance.

Max

1 Reply
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies