My issue was the file was so unstable it crashed every time I tried to run VBA or recalculating, landed up just deleting worksheets until the file size shrunk identifying the offending location and then could just clear all the formatting and start again
My issue was the file was so unstable it crashed every time I tried to run VBA or recalculating, landed up just deleting worksheets until the file size shrunk identifying the offending location and then could just clear all the formatting and start again