How to reduce file size of photos inserted in Excel

[Guest]

Just finished an entensive household inventory in Excel, including photos of
each item, but the file size is 250,000KB (photos taken at highest
resolution). How can I do a reduction of the file size in the fastest,
easiest way so that I don't have to do each one by one?

(e-mail address removed)

 

[raypayette]

Reducing the picture in Excel will not do the trick. It is best to
reduce the pictures with a paint software (some have batch editing)
outside Excel, Then paste them in Excel.

 

[Guest]

If each photo inserted was high resolution when inserted (a few hundred
images), is there a way I could reduce the size of all of them at the same
time, instead of having to go back to Photoshop and reduce each one
individually and replace one by one?

(e-mail address removed)

 

[Guest]

right click one picture, select format picture, then click on compress and
select 72dpi for maximum size reduction, click all pictures in file and save
excel sheet under a different name.

All pictures inside the excel sheet will now be reduced in size.

If each photo inserted was high resolution when inserted (a few hundred
images), is there a way I could reduce the size of all of them at the same
time, instead of having to go back to Photoshop and reduce each one
individually and replace one by one?

(e-mail address removed)