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