Links not updating automatically

[Farzana Saleem]

There is a database of Job Descriptions in Excel. Job
descriptions for each job code are written in a Word File.
Headings for each part of job description are copied in an
Excel column using Paste Special -> Paste Link -> Text.
Purpose of this link is to automatically update the Excel
file whenever any change occurs.

The problem that I am facing is that when I change
anything in job description (MS Word file), changes don't
appear in Excel columns automatically. Changes appear only:

1. When I click Edit -> Links -> Update Values
2. When I reopen the file and clik update button in Update
Links message box

I checked the following:

1. Tools -> Options -> Calculation (Automatic is selected)
2. Workbook options (Update remote references is checked)
3. Edit -> Links -> Update (Automatic is selected)

 

[Guest]

AFAIK that is how it works, but you could program the spreadsheet to update the links when you recalculate.

 

[Farzana Saleem]

Thanks

Also, with increase in number of job descriptions, excel
is taking too much time to save the file and update the
links.

Is there a way out or is there any better way to manage
this database of job descriptions.

-----Original Message-----
AFAIK that is how it works, but you could program the

spreadsheet to update the links when you recalculate.

 

[Guest]

Perhaps you should consider doing this the other way around? i.e. keep the descriptions on a worksheet and set up your written job descriptions as a word mail-merge document. Would only work if the job descriptions were tightly structured.