Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |