"Your formula contains an invalid reference to a worksheet" turns out to be caused, at times, by deleting cells that are referenced from a Chart.