Excel spreedsheets that are linked to other documents. #REF!

[mmollat]

Ok, I've already posted why i get a value change even though i hit dont
update on my excel sheet. There was a regedit fix for it. However even though
i have that fix on this one particular file I still get the #REF! error.

This time what happens is this. I open the file, then i select dont update.
The values don't change. But as soon as I insert a new column my values then
change to #REF!. I can't figure this out. I'm stuck!

I'm currently running Office 2003.

Thanks,
Mark

[Harlan Grove]

mmollat wrote...
>Ok, I've already posted why i get a value change even though i hit
dont
>update on my excel sheet. There was a regedit fix for it. However even
though
>i have that fix on this one particular file I still get the #REF!
error.
>
>This time what happens is this. I open the file, then i select dont
update.
>The values don't change. But as soon as I insert a new column my
values then
>change to #REF!. I can't figure this out. I'm stuck!
>
>I'm currently running Office 2003.

What do these formulas look like? That is, what function calls do they
include? If they include ANY volatile function calls, they'll
recalculate whenever anything changes that triggers an automatic recalc.

[mmollat]

the formula looks like its pointing to a file on a local directory of the
creator of the spreadsheet. I assume all the cells are tied together because
if I do anything vaules on certain cells change to #REF!. What I dont
understand is why only those certain cells change and the others dont when
they have a similar formula.

It's more frustrating then anything. You would think after applying the
regedit fix and when you click "dont update" the issue would be fixed...
guess not!

>
> What do these formulas look like? That is, what function calls do they
> include? If they include ANY volatile function calls, they'll
> recalculate whenever anything changes that triggers an automatic recalc.
>
>

[Harlan Grove]

mmollat wrote...
>the formula looks like its pointing to a file on a local directory of
the
>creator of the spreadsheet. I assume all the cells are tied together
because
>if I do anything vaules on certain cells change to #REF!. What I dont
>understand is why only those certain cells change and the others dont
when
>they have a similar formula.
>
>It's more frustrating then anything. You would think after applying
the
>regedit fix and when you click "dont update" the issue would be
fixed...
>guess not!
....

You can either copy a sample formula evaluating to #REF! into your next
follow-up, e.g.,

='C:\foo\[bar.xls]whatever'!$X$99

or you can continue to give prose descriptions of your problem
formulas. The former is far more likely to get you useful help SOON. Up
to you how much longer you want this problem to persist.