Diagram in Excel 2007 dissapear after file opening

[gliwice23]

Hi here,

I hope someone can help me to resolve my excel issue.

It's regarding a diagram where all data are taken from a pivot table and SAP. The data sheet for one of the tables has been hidden in the workbook (even when I try to unhide it, the diagram is still not present). Both pivots are present in the same sheet as the diagram. I've checked the option under excel options - advanced - display - show all objects. Additionally I changed the default printer (one of solutions from the web), removed the sheet, created a new one but the issue is still there.
Funny thing, when I open the file, the diagram is not being displayed, but when I switch to a different sheet and go back to the previous one then (do not know how) the diagram is there..


Is there any setting which should be changed to eliminate this "interesting" problem?