Add the ability to paste pictures directly into a cell
It would be very helpful to have the ability to paste an image directly into a cell in an Excel file. And then within that cell you can still resize the image so that your row/column isn't a crazy size. That way when rows or columns are grouped together & collapsed then the image would also collapse with the designated cell.
I work for an interior design firm and my company uses Excel for all of our Furniture, lighting, Art & accessory procurement. We need to include images in these documents to send to clients, trades and for installs. When we go to sort to or collapse rows/columns it causes us to have to select all of the images and move them out of the way or delete in order to print. (and then of course we have to remember to not save any changes made to the file when doing so) It just can get very messy and adds a lot of busy work.
Have you tried Access? You can attach files/photos to a record. Keep the calculated data in Excel but link it to your Access database. For sending info to clients, use Access to create a "report". I'm no Access expert but from the little bit I've used it, I think it would better suit your needs... well, a combo of Excel and Access anyway.