#name? question

[randomwalker]

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!

 

[ADAMC]

Whats the formula...It could be when you are changing a positive to a negative.....