120 small images making workbook 37mb!!

N

neowok

I have a workbook with 4 sheets, 3 sheets just have some organagram
that dont take up much space. the 4th sheet has about 120 smal
pictures on it, of maybe 100x90 pixels each, and taking up betwen 30
and 50k each. At worst this should equate to maybe a 6mb workbook a
45kx120 + the organagrams which are just using cells not diagrams.

So how comes its 37mb!!!

I have compressed the pictures (hence they are only between 30k and 45
each!) so it shouldnt be anything to do with that.

It IS the images because deleting them all reduces the workbook size t
300k !!! any ideas how to fix it
 
N

Nick Hodge

I could be rude and say Excel is a spreadsheet...but no ;-)

There is no way to change this. I suspect some of the bloating is because
xl saves a placeholder for these objects and I suspect it also saves some
other webcentric stuff to.

I presume you are not saving this in one of XL's dual formats?
XL5/95&XL97-2000 or similar?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
N

neowok

nope saving it as excel xp workbook.

excel may add some bloat but come on, it cannot go from a potential 6m
to 37.5mb!!!!! that would make the additional bloat over 6 times th
size of the pictures and other sheets combined
 
J

Jon Peltier

If you add the picture using Insert menu > Picture > From File, the
Excel workbook is only increased in size by about the size of the image
file.

If instead you open the image file in an image editing and viewing
program, then copy the image, and paste this in Excel, you are copying
the bitmap representation of the image file. This is much larger than
the image file, so your workbook is bloated by many times what it could be.

Although 100x90 pixels even at 24 bit true color produces a bitmap file
of only 27k, smaller than your 30-50 k stated file size. Are the images
imported then shrunken to 100x90?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
N

neowok

they arent all exactly the same size, some are slightly bigger lik
98x129 and this one is 37926 bytes. I checked and there arent any hug
ones there. They are in 24 bit colour.

Im not sure how the pictures were added as its not my spreadsheet i
just trying to fix it for someone else.

They are pictures of peoples faces grouped together with a litl
textbox containing the name.

I just find it highly strange that it would be THAT much bigger tha
the theoretical 6mb or so total file size that I would expect it to be
It's also a problem because this is going to expand with mor
pictures
 
J

Jon Peltier

Strange indeed.

I'm remembering a problem I had with a project long ago. I used VBA to
insert files into the workbook. VBA lets you dump lots of files in a
very short time. It seems to me Excel would get bogged down with it. I
don't remember the files blowing up in size, but the temp folder filled
up with temp files, and you couldn't delete them until after you quit
Excel (or it crashed; this was '97).

You should make sure the old pictures are really deleted. If the rows
and columns under a picture are deleted, the picture may remain behind,
shrunk to 0 pixels in width but still requiring all that memory.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
N

neowok

I did try deleting half of the pictures and it did dump the size down t
14mb so its not duplicate pictures causing it. it would seem for som
reason each picture is taking up a lot more space than the 35-50k eac
picture is.

I just tried deleting one picture (and the text box grouped to it wit
the persons name) and it reduced the filesize by 603kb, yet the pictur
was only 28638 bytes according to image editor.

So unless the grouping of a small text box with the picture is addin
550+k to each picture, something very strange is happening
 
N

neowok

I dont know whats going on but I just took out one of the pictures an
saved it as a png. deleted it in the sheet then went to add pictur
and put it back, it saved nearly 600k

it must be something to do with how hes added these pictures but
still dont see how it culd possibly have this effect on it
 
L

lunker55

Maybe he imported a 600k picture and just shrunk the picture visually,
leaving the picture the same file size.
Can you blow up the picture and still have the quality?

Joe
 
J

Jon Peltier

This is what I was getting at with a couple of my posts. The pictures
were copied from Photo Editor (or another editing program), which
converts them to bitmaps, then pasted into the worksheet. Then they were
shrunk from full page size to thumbnails, without actually changing the
size of the file and deleting any pixels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Maybe he imported a 600k picture and just shrunk the picture visually,
leaving the picture the same file size.
Can you blow up the picture and still have the quality?

Joe
Click to expand...
 
Top