Links not updating automatically

[FarzanaSaleem]

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)

 

[macropod]

You could cure this by adding an auto-execute macro to the Excel workbook to automate the Edit -> Links -> Update Values process.

Cheers

 

[FarzanaSaleem]

Thanks.

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

It seems that I will have to look for some other solution.

Please advise if there is any better way to manage this database of job descriptions.

 

[coachdan]

Why not move it into Access where it is more suited to do the job?

coachdan32

http://www.highviewheat.com/index.asp

http://www.kristensfastpitchworld.com/index.asp