This should be easy be somehow the hour is either late or my brain isn't working...
I have a very simple 'data-entry' style spreadsheet. No calculations, macros or conditionals. Figures are added manually. The spreadsheet also incorporates images that have been pasted into cells (no links back to original files). My problem is that several users have imported images without resizing or compressing them. As a result the file is HUGE. No surprise there.
The spreadsheet is duplicated - so that the workbook contains 10 Sheets (each sheet is set out identically).
What I'd like to do is select all the images in the the workbook and compress and resize them - while at the same time enlarging their respective cells.
Any help gratefully received.
Bookmarks