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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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.
 
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!
 
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!
Click to expand...
....

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.
 
Back
Top