Insert figure blocked in workbook

[KayMan]

I have a workbook, where the entire insert function is blocked for all graphic objects. (pictures, figures, smartart, diagr etc)



Have been trying all ways and corners to find out what's special with the workbook. No clue so far.

[Colin Legg]

Welcome to the forum.

2 ideas immediately spring to mind -

Are the worksheets in the workbook protected?
Is the workbook shared?

[KayMan]

No sharing, no protection

[Colin Legg]

Perhaps you could remove any sensitive information from the workbook and then attach it to this thread so we can see it too?

[KayMan]

I've sorted out the problem by copying all the pages to a fresh workbook, which works OK, so the problem must be hidden i the container.
If you still like to see a 'tamed', but erroneously working workbook, tell me. /K

[Colin Legg]

If you still like to see a 'tamed', but erroneously working workbook, tell me.

Sure, I'm intrigued and, if we do find the reason, it might help someone else in the future!

[KayMan]

the 'erroneous container' is attached.
/K

[Colin Legg]

Thanks, that helps. The problem is with that workbook's settings where objects are set to hidden.

Click on the Office button > Excel Options > Advanced
In the "Display Options For This Workbook" section, choose the "For Objects Show ALL" option.