Excel - no insertion of pictures and charts possible

Hi all,

I have a rather huge excel (about 40M file size) with a lot of rather complex calculations (over 500.000).

Might be this is the reason ... but I can't insert a picture or a chart anymore. The respective icons are grey, copy&paste a picture leads to no results and insert over file explorer isn't possible.

I use Office 365 under windows 10.

As I haven't found any relevant information about this issue it might be coming from size and complexity of my sheets ... but perhaps there is another reason for it ?

Thanks for your help,

Martin

Charts & Visualizing Data

Excel Desktop

Anonymous
Jul 18, 2017
Hi,
maybe the problem is related to the settings for displaying objects. If you go to the Excel options, is the setting for showing objects (in the category Advanced) set to "Nothing"? If yes, then please set it to "All".

Best,
Mourad

6 Replies

Detlef_Lewin
Silver Contributor
Jul 16, 2017
Greyed out icons usually refer to some kind of protection (workbook or worksheet).
Or it is a shared workbook where some features are not possible or allowed.
- M. Leviathan
  Copper Contributor
  Jul 16, 2017
  Both not ... there is no protection (in this sheet) and it's not shared.
  If I open a new workbook all functions are usable.
  - Anonymous
    Jul 18, 2017
    Hi,
    maybe the problem is related to the settings for displaying objects. If you go to the Excel options, is the setting for showing objects (in the category Advanced) set to "Nothing"? If yes, then please set it to "All".
    
    Best,
    Mourad

Forum Discussion

Excel - no insertion of pictures and charts possible

6 Replies

Resources