Circular Reference Warning When Opening Workbook

[fredfarmer]

Hi,

I get a warning of circular reference.

I think it's in formulas on sheet LookupLists E13:I13

I did this to remove the spaces in the drop down lists in the AFRsInput sheet.

Can someone figure out how to correct this please?

Thank you,
FF

[Keebellah]

There is an option in Excel to show which cell is point to where, it can be that you have a formula addressing a cell that itself is pointing to a cell that depends on the formula.
Troubleshooting is the toughest thing to do, and time is what you need

[fredfarmer]

[Keebellah]

Here some more concise information
https://support.office.com/en-ie/art...7-1b49cd50d123