Auto Update Linked files (Excel 2002)

I have a client that has 20 files that are linked to a summary sheet. Many different users updates these sheets. In Office 97, the summary sheet would be automatically updated whenever the data was changed in the linked sheet. This stopped working in Excel XP(2002). The client must now manually run update on either the input sheet or the summary sheet to see the updated data. Since the only thing I know about Excel is how to make a list, I'm a little bit lost. Any help would be appreciated.

Re: Auto Update Linked files (Excel 2002)

Hi,

You might be able to fix this by going into Tools|Options|Calculation and checking the 'Update remote references' checkbox.
You might also want to make sure the 'Ask to update automatic links' checkbox under Tools|Options|Edit is checked too.