is it possible to make comment appear faster in excel?

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

Was this solution helpful to you?

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

Just Added Q & A:

Find solution

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.