none
EXCEL PICTURES LIMIT RRS feed

  • Question

  • Hello,

    I am preparing a pricelist with 3000 items that require picture in excel.

    Excel crashes around 500 pictures even if they are compressed, low dpi etc.

    Is there a solution for this?

    Excel 2010 and newer

    regards

    Thursday, February 6, 2020 7:02 PM

All replies

  • To:  Marek CDD
    re:  pictures on worksheet

    You can add pictures to comments.
    (in XL rental version Comments are now Notes and Notes are now Comments)



    Debra Dalgleish has instructions at: 
    https://www.contextures.com/xlcomments02.html#Picture
    This can also be done using VBA, as the above file was.
    XL 2010 handled several thousand of these in one trial.

    '---


    The new (free) Excel workbook "Professional_Compare" is now available at MediaFire.
    (compares every cell Or every row in two worksheets - choice of compare type)
    Download (no ads) from: 
    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents
    Friday, February 7, 2020 10:37 AM