It's both. Most of the named ranges only exist on the second tab. They just need purged from the name manager and recreated.