randomwalker
Board Regular
- Joined
- Feb 22, 2007
- Messages
- 169
Hi,
I understand once come across #name? error in spreadsheet, it means Excel doesn't recognize a name used in a formula. But I very carefully checked every formula I used in a spreadsheet, I cannot find out anything wrong. Is there any other possible reason causing this error? Actually, this error doesn't pop up during the first about 30 minutes after I build a model in the spreadsheet, and it popped up after I change the positive sign in a formula to the negtive sign.
There is a circular reference among the formulas in the spreadsheets, but I have already go to Tools>Options>Calculation tab, and tick the interation box.
Can anyone here help?
Thanks so much!
I understand once come across #name? error in spreadsheet, it means Excel doesn't recognize a name used in a formula. But I very carefully checked every formula I used in a spreadsheet, I cannot find out anything wrong. Is there any other possible reason causing this error? Actually, this error doesn't pop up during the first about 30 minutes after I build a model in the spreadsheet, and it popped up after I change the positive sign in a formula to the negtive sign.
There is a circular reference among the formulas in the spreadsheets, but I have already go to Tools>Options>Calculation tab, and tick the interation box.
Can anyone here help?
Thanks so much!