I would keep each of the 40 images as single files and import those
individually into Excel if you want them as single images.

40 images in one file sounds like a Contact Sheet to me.

I used IrfanView graphics application to make a contact sheet with 40 *.jpeg
photos and saved as Import.tif

InsertPictureFrom File

Excel happily imported the entire file as one large image..........2.6mb

I don't know how your 40 pages in one file are saved as one image file so
can't help with that.


Gord


On Tue, 4 Aug 2009 15:32:02 -0700, John Calder
wrote:

Gord

Our photocopy machine allows you to send documents to an email address in
either .TIF or .PDF format. It allows for the pages to be sent singular
(therefore creating multiple images) or as one file, in which case all 40
pages would be on the one image.

TIF iamages are usually quite big so maybe the issue is file size related?

I would probably breakup the images into single pages before inporting.

Cheers


John


"Gord Dibben" wrote:

TIF is a graphics file.

How can it have 40 pages?

Or am I about to learn something new<g


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 11:46:02 -0700, doyree
wrote:

I have a tif file with about 40 pages.
i want to insert all 40 pages in excel.
how can i insert all 40 pages?
when i do insert picture, it only shows the first page of picture thats it.

please help
thank you