Hi there,

I'm running MS Excel 2003. I have linked workbooks - the children (6
of them) are hosted on local servers, the parent national report is
hosted here on our corporate server. Once the local admin teams have
updated their data I update the links for the national report.

For reasons unknown to me one row of cells in the report always
returns "#NAME?" when I update the values. This is consistent for all
6 worksheets. The cell reference seems good to me - it is identical to
every other cell on the spreadsheet, and once I open the source
workbooks the values populate. It's not a show-stopper but it's very
annoying, because I don't want to have to open all the remote sources
every time I update my data.

Does anyone have any suggestions?

Thanks,

R