ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

It is possible to create a dynamic connection between a file Excel and a Word file ?

user-image
تم إضافة السؤال من قبل Safia Abaoui , Teacher in private , private intensive courses
تاريخ النشر: 2013/12/27
Mohammad Rizwanul Haque
من قبل Mohammad Rizwanul Haque , Administration Manager , Oren Hydrocarbons ME FZCo.

YES !!!

Mostafa Khamies Dakam
من قبل Mostafa Khamies Dakam , Network Specialist , Libyan Fertilizer Company

Yes it can be done

BADR ALTALHI
من قبل BADR ALTALHI , sales manager , Arabian Centres

yes , there is many ways .

Islam Taha
من قبل Islam Taha , Technical Service Engineer - Middle East & Africa Region , 3M

You can do so, by copying the cell in excel, and then in the word file, choose paste special, from which you should choose "Microsoft Excel Object" option

Mohammed Yaseen MBA  PMP®
من قبل Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Yes >. .>>

Dynamic Linking (automatically detecting changes in data and updating accordingly) This is perhaps the most useful:  

#To do this follow the same instructions as (2.) however when you open the paste special dialog box click:  

- Microsoft Excel Worksheet Object as usual - AND select the paste link radio button This means that when you make changes to data into your spreadsheet the data in word will change accordingly. When using dynamic linking you should be aware: - To keep the original data saved on the spreadsheet, if this data is deleted or unsaved then the data in the report will be affected (cleared also) - any formatting or changes made to the cells in the spreadsheet, that have a dynamic link with word will also update in word.

- I would suggest you protect the data in the spreadsheet: To do this select the data that is important (The data with the dynamic linking)>>right click>>Select format cells>>Click on the protection tab>> Select lock cell Nothing will happen until you protect sheet: click tools from the menu bar>>protection>>protect sheet>>protect sheet dialog box will appear, you can select the conditions and even enter a password needed to unprotect the spreadsheet in future time.

Huda Baloum
من قبل Huda Baloum , Administration Supervisor , Jordan Golden Jewel Co.

Yes using mail merge.

Rehan Farooq
من قبل Rehan Farooq , WEB DEVELOPER/DIGITAL MARKETING EXPERT , Upwork

Yes it is possible and can be linked together , when data in excel sheet is updated it will automatically update in word document as well.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

Yes.....

When you want to create a dynamic link between the content of your document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when you paste content (such as by pressing CTRL+V), when you insert it as a linked or embedded object, you can work with it in the original program.

FITAH MOHAMED
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

yes there is many ways like hiper link

farhan ali
من قبل farhan ali , DMS OFFICER , BANK ALFALAH LIMITED

yes its possible through adobe Adobe Acrobat7.0 Standard

المزيد من الأسئلة المماثلة