Updating links error

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

If you have a formula which is returning an error, and if you want the
assistance of the group in solving your problem, you have 2 options:
1 Let the clairvoyants on the group guess which formula you might have
used.
or
2 Tell us the formula.
--
David Biddulph

"RPS" wrote in message
...
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

If you select one of those offending cells and hit F2, then Enter, does the
formula evaluate correctly?

If yes, I've seen some posts that describe problems when people open their
workbooks that contain links.

I've never seen this situation in real life, but one suggestion to fix those
errors is to select all the cells and do an edit|replace to replace all the =
(equal signs) with =. It'll cause excel to re-evaluate all the formulas. (Do
it for each worksheet--or have a macro do it for you.)

A question for you (I don't know if your response help anyone, though):
Do you have any UDFs in the workbook that's being opened?

RPS wrote:

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

--

Dave Peterson

On Oct 7, 6:28*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote:
If you have a formula which is returning an error, and if you want the
assistance of the group in solving your problem, you have 2 options:
1 * *Let the clairvoyants on the group guess which formula you might have
used.
or
2 * *Tell us the formula.
--
David Biddulph

"RPS" wrote in message

...



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- Hide quoted text -

- Show quoted text -

It feels insulting to the group to paste this - as I said it's just a
direct reference to another workbook. The same formula operates across
rows 1-30, but consistently fails in row 17.

=IF(('\\Corporate-FS01\Home$\rsutherl\1_XXX_Sales_Capability
\1.1_Accelerator\2009_C7\4.0_Weekly_Reports\VIC\[2_DG_VIC_C7_09.xls]
Summary'!D16)="","0",('\\Corporate-FS01\Home$\rsutherl
\1_XXX_Sales_Capability\1.1_Accelerator\2009_C7\4. 0_Weekly_Reports\VIC
\[2_DG_VIC_C7_09.xls]Summary'!D16))