Autocat error when running Autocat

When I run Autocat I get this error. Autocat error. “The data in cell D90 violates the data validation rules set on this cell.” Cell D90 is empty. I am also a novice in excel. Any help would be appreciated.

It might mean the Category specified on the AutoCat sheet does not match a Category on the Categories sheet, and so when AutoCat attempts to write the Category to the Transactions sheet Category cell D90 it fails with the Error message.

Thank you. Your solution worked.

1 Like