Hey all,

new to the forums, and am in need of some very quick help as I've never seen this issue, and the guy that needs it is A) a **** & B) impatient.


We have I would say...thousands of excel files, each with about 10 internal sheets in each. The problem lays with the individual .xls files.

The basic way of linking internal worksheets from 1 to the other is =otherworksheet!A1 that works fine in some xls files, some it doesn't. The ones that it doesn't work in, you have to save the document first, and then it updates the linked field.

Any idea on how to fix this? I don't get any error of any kind (unfortunately). Is this an issue with protection?


all help appreciated,
10