Forum Discussion

Copper Contributor

Jul 16, 2017

Solved

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...

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

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
- Stugoinggreyer
  Copper Contributor
  Feb 18, 2021
  Thank you so much - it works office 365 in Excel current update 18/02/2021
- M. Leviathan
  Copper Contributor
  Jul 20, 2017
  Hi Mourad,
  
  perfect ... that works. I had never changed that settings. So I was a little surprised and feel a little ashamed ... should have found that myself ;-)
  
  Thanks a lot,
  Martin
  - Thomas Marx
    Copper Contributor
    Aug 11, 2017
    I had the same problem and the recommendation fixed mine as well. Thank you..