Hi Tim,

Thank you for your reply
I didn't explain well enough I don't think.

If A = WrkSht 1 WrkBk 1
B = WrkSht 2 WrkBk 1
C = WrkSht 1 WrkBK 2

So A contains data in number format.
B contains function Countif summarising data for individual depot
C contains copy and pasted formula from B.

Formula works fine in B and copies to C but shows error message when updated.

I'm totally fuzzy on how the link works and what is "actually" stored in
each cell so I'm having trouble visualising what happens.

Any help appreciated
TIA
--
Smudge (dazed and confused)


"Tim879" wrote:

The #Value! error occurs when you use the wrong type of argument (i.e.
if you try to sum "abc").

You most likely have an error in one of your source files. Try opening
all of your source files and searching for #Value!. Alternatively,
select a cell with the #Value! error and use the Formula Auditing
Toolbar (View- Toolbars - Formula Auditing) to trace the error.

It may also help to check your links. You can also try to use the Edit-
Links and verify that each of the links is working.



On Aug 30, 3:00 pm, Smudge wrote:
Hi everyone,

Excel 2003 Windows XP

I really need help.

Over the last couple of days I've been copying cells from several workbooks
to a summary workbook. The cells from the source workbooks pick up data from
individual worksheets using a countif function.

all well and good until I re-open the summary workbook and it asks if I want
to update or not. Tried updating once and got VALUE in all of the copied
cells so quit witout saving and opened without updating.Fine
Then decided that Excel wouldn't beat me and tried altering the update links
bits in Tools Options but should have put brain in gear first. I removed tick
from ask to update external links and also save external link values so when
i saved and opened it open and I think it updated links automatically and I
hadn't made a back up.

Please, please can someone tell me how to make the values come back instead
of the nightmarish #VALUE.

If it helps to know the source and summary workbooks are both on the same
server but in different folders.

TIA
Smudge
--
Smudge