Avert Excel from displaying Messages when opening a file

[jofoko]

Hello,

how can i avert Excel from showing me a message, that this workbook contains circular references, when opening the file.

I cannot avoid this circular references. I don't calculate in this Workbook, but copy the formulas into another Workbook, so the circular references are solved.

I already tried a lot, but couldn't manage to avoid this message. Is it possible anyway???

Any idea????

thanks for your help

 

[rmikesmith]

jofoko,

You say you cannot avoid circular references. However, circular references are usually accidental (although some formulas do require them). If so, you can select OK when you get the message and use the Circular Ref toolbar to help trace/fix the problem. I don't know of any way to stop the message from displaying other than to remove the circular references.

 

[rmikesmith]

jofoko,

You say you cannot avoid circular references. However, circular references are usually accidental (although some formulas do require them). If so, you can select OK when you get the message and use the Circular Ref toolbar to help trace/fix the problem. I don't know of any way to stop the message from displaying other than to remove the circular references.