auto calculate not working - UDF's and external workbooks

[GaryStainburn]

Hi folks.

Back in September I asked for help on here to get a workbook working. It involved opening two other workbooks when the main workbook is open, so that cells containing user defined functions will work.


Thanks to people on here, I got this working. Unfortunately, although the automatic opening of the dependant workbooks still works, the cells are no longer being recalculated.

I have opened each workbook separately, as well as collectively and everything has auto calculate set to automatic. However, I have to press <f2> are return for each cell to get each cell to recalculate.

Does anyone have any ideas what I can do next to sort this?</f2>