We help IT Professionals succeed at work.

Referencing an image MS Excel

WTC_Services
WTC_Services asked
on
Hi,

I have an Excel document with multiple worksheets, and at the top of each sheet is an image of the company logo. Is there any way I can make this image on each sheet a reference to a single image to cut down on file size?

Thanks, WTC
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

use the dialog to insert an image, browse to the file location. Click the Insert drop down and select Link to file.

Repeat on each sheet. This way, the image will only be linked and will not take up space in the file.

cheers, teylyn
3-11-2011-11-32-47-a.m..png
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
Why not put the image in the header? Then only one copy is needed.
A) Insert (Not copy/paste) the logo / image in one sheet for the first time.
B) Now you copy the image from the first sheet and paste in other sheets.
C) This way Excel will know that you are using a single image into multiple sheets.


Example: In my attached the file with one image is 32 KB in size
                And it is only 42 KB with multiple image. Multi-Image.xlsx
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Could this be a suitable use of the Camera function?

I have just created a basic sheet with a clip art picture. File size 13.5 Kb

I have replicated the clip art area using the camera function nine times and the file size is now 19.0 Kb

The advantage with this as well is that if you change the original clip art, the others change too.

Thanks
Rob H
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Also, if the image causes file size bloat, it is probably resized to appear smaller. Use an image editor to scale the original image down to the size that you need in the Excel file, then insert (or link to) the scaled version.

A 2MB image, inserted into Excel, then dragged down to stamp size will still clock up 2MB in the Excel file. Using an image editor to scale it will yield a file that should not be bigger than a few dozen KB.

Author

Commented:
Thanks guys, all very helpful. I took teylyn's original solution in the end.

WTC

Explore More ContentExplore courses, solutions, and other research materials related to this topic.