how to reduce excel file size (since many photos inside file) ?

Question

My excel file size is too large, about 590MB, how to reduce it to an acceptable size ?

Answer 1

Define "acceptable".

You could delete some photos.
You could pre-process those photos and reduce their size before adding them.
You could leave the photos in the file system and never add them - maybe just add their file path so you can programmatically pull them in as-needed.
You could zip or 7-zip the file to reduce the size.
You could split the file up into several smaller files.

Does any of the above get you to "acceptable"?

Answer 2

A XLSX is already a compressed ZIP file and what do you expect when you use an Excel file as a "photo container"?

Answer 3

Hi @hui johnson

Here is an article, you may have a look: Reduce the file size of your Excel spreadsheets.

It tells us the following options to try:

• Save pictures at lower resolutions
• Compress pictures
• Don't save the pivot cache with the file

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---