Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

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

--

Dave Peterson