Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Safia Abaoui , Teacher in private , private intensive courses
Date Posted: 2013/12/27
Mohammad Rizwanul Haque
by Mohammad Rizwanul Haque , Administration Manager , Oren Hydrocarbons ME FZCo.

YES !!!

Mostafa Khamies Dakam
by Mostafa Khamies Dakam , Network Specialist , Libyan Fertilizer Company

Yes it can be done

BADR ALTALHI
by BADR ALTALHI , sales manager , Arabian Centres

yes , there is many ways .

Islam Taha
by 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®
by 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.

Mohannad Asad Mesheh
by Mohannad Asad Mesheh , Data Analyst , Tech Mahindra

yes U can

Huda Baloum
by Huda Baloum , Administration Supervisor , Jordan Golden Jewel Co.

Yes using mail merge.

Rehan Farooq
by 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.

Deleted user
by Deleted user

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
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

yes there is many ways like hiper link

farhan ali
by farhan ali , DMS OFFICER , BANK ALFALAH LIMITED

yes its possible through adobe Adobe Acrobat7.0 Standard

More Questions Like This