#Name error
 

I have a workbook with 3 worksheets. On one worksheet are control
numbers that are easily changed, e.g interest rates. Reference to
these numbers are included in formulae in the other worksheets.

When I send this workbook to another user via email and the user makes
a change, like deleting a line, the #NAME error is displayed in all the
cells linked to the formula. I had previously named the cells with the
control numbers but have since taken these off when the error first
occurred.

Has anyone else experienced this problem with excel and were you able
to fix it ?

Not exactly using excel to do anything difficult !

thanks


--
LisaA
------------------------------------------------------------------------
LisaA's Profile: http://www.excelforum.com/member.php...o&userid=26876
View this thread: http://www.excelforum.com/showthread...hreadid=401117