Linking Excel data to Word docs: Portability?
-
I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? Bonus: It's clear that my project (there are probably 300 Excel cells that show up in 6 different Word docs) pushes Excel/Word's limits. The excel document is very unstable and freezes/crashes when opening the Word doc. What kind of technology/skillset would be ideally used to accomplish this? Note -- the Word docs have to have consistent formatting (they are used to print client-facing communications) and the process of entering data into the Excel, and then generating the populated Word doc, is being done by extremely nontechnical users.
-
Answer:
Standard database publication tools: web form and a markup processor, or PDF forms being fed from a database backend, or Google Docs mail merge, or ...
stupidsexyFlanders at Ask.Metafilter.Com Visit the source
Other answers
You have to find and replace the filename of the link when you save the files in a new place. If you are working on a shared network drive, try working on your C drive and the file may not crash as much.
kmr
If you're just generating word documents for printing (ie: static display), could you just use mailmerge? Re-linking a mailmerge data source is going to be a bit easier (ie: one step) than updating however many (>1) links.
pompomtom
Related Q & A:
- How To Search Docs?Best solution by Web Applications
- How to covert csv file to excel and back excel file to csv in python?Best solution by completecampaigns.com
- How can i attach word,excel,mp3,picture files to e-mail messages in yahoo mail quickly?Best solution by Yahoo! Answers
- What does linking mean?Best solution by Yahoo! Answers
- How to make Outlook 2007 as default for emails while sending files directly from Word or Excel as attachments?Best solution by Super User
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.