I get the error message 'Reference is not valid' when I open my worksheet. I don't know what reference is not valid. The worksheet has no pivot tables, no hyperlinks. It does contain charts and sumproduct formulas.

Any ideas what the problem is?

Thanks