Export to Excel - problem with images

Question

Level 1

9 points

Export to Excel - problem with images

Hi,

I've read a lot of posts on this already but haven't found one that exactly fits my problem. I have a numbers file with a worksheet that has approximately 300 images. They are all .png and are not "image fill". When I export it to Excel the images disappear from the main worksheet and it creates a second worksheet with the same name and the word "Drawings" added to the end. This worksheet is full of my images. The whole point of my spreadsheet is so that other people (Excel users) can correlate the images to some text which is not possible when they're in 2 different worksheets.

I've done the exact same thing before and can continue to do so with different files. I am getting the impression that maybe the problem has something to do with the heaviness/number of images but I can't really remove them. Any suggestions?

Thank you!

Posted on Jun 16, 2017 7:24 AM

Reply

Answer 1

Jun 16, 2017 7:30 AM in response to braz1lnut

my recommendation for this situation is that since it is essential that MS excel users be able to read the file you should create the content in MS Excel. Numbers is not equal to excel and how it treats pictures and how excel treats pictures is clearly different.

You may continue to use Number and excel and you may get something that works, and then Apple (or Microsoft) coulee change Numbers (or Excel) with an update and your "working" solution may break.

You other option is to try LibreOffice (or other open office clone) or try exporting from Numbers to a PDF which your Excel users may view (but not modify)

Reply

Answer 2

SGIII

Level 8

37,764 points

Jun 16, 2017 7:36 AM in response to braz1lnut

braz1lnut wrote:

The whole point of my spreadsheet is so that other people (Excel users) can correlate the images to some text

Do the images show up correctly in Numbers for iCloud. If so you could have the recipients view the document there by sharing the link. No Mac required, just a modern browser.

SG

Reply

Answer 3

braz1lnut Author

Level 1

9 points

Jun 16, 2017 7:40 AM in response to Wayne Contello

Hi Wayne,

Thanks for the quick reply. I don't have Excel and I think that's a shame to have to not be able to use Numbers freely. I was hoping for an in-Numbers fix. It works mostly fine for everything else. It would be a shame to have to switch over to Excel just for this.

Reply

Answer 4

braz1lnut Author

Level 1

9 points

Jun 16, 2017 7:43 AM in response to SGIII

Hi SGIII,

Thanks for your reply. I will check this one out but my client involves 2 big companies and I don't really want to use a workaround. I would just like it to work like normal, like I can do with practically every other numbers file I have. It would be great if you have some advice on this. Thanks!

Reply

Answer 5

SGIII

Level 8

37,764 points

Jun 16, 2017 7:51 AM in response to braz1lnut

my client involves 2 big companies and I don't really want to use a workaround

If your clients are big companies they very likely are familiar with compatibility issues with different software packages. If they're on Excel then you'd best be on Excel too, just as Wayne is advising.

If your clients don't mind using web access (that's quite common these days, with both Excel and Numbers users) then that's a potential solution, not a "workaround."

If you think Excel and Numbers should have 100% compatibility with each other you could of course give feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

You may be expecting too much, though, and hope you give Wayne's suggestion serious consideration, and also check out the web access to see if that might be a possibility.

SG

Reply

Answer 6

Peggy

Level 8

41,971 points

Jun 16, 2017 8:38 AM in response to Wayne Contello

Link for LibreOffice

Reply

Answer 7

braz1lnut Author

Level 1

9 points

Jun 20, 2017 1:10 AM in response to SGIII

Thanks Everyone. We have decided to just buy Excel. Pity, but oh well. Thanks for your help!

Reply