· Ipswich, England MSOff Ver MS 365 Subscription Insider (Windows 11 64bit) Posts 52,181. Re: Conenate not working No need to delete the formula. I've not been able to fix it without deleting the formula when it has happened to me. Register To Reply., 12:02 PM #5. Tony Valko . View Profile View Forum Posts Forum Guru Join Date Loion Pittsburgh MSOff .