Optimising Picture Size With Compression

I'm adding pictures to my Excel 2010 document via Comments. Every time I open the document my picture sizes are changed from how I originally formatted and saved them.

Is there a way to make the sizes static, so that each time I (and the end user) open the document, my comment pictures will stay the size that I originally specified them?
Thanks much for any help you can give me.

Hi,

When trying to compress a very large Excel file (>30MB) either with Winzip
or WinRar, the compression does not result in a significant reduction (max.
-3% only in the best compression mode).

From my experience it seems to me that there is something like a
'hidden/magic' limit around ~25 MB and below this a compression is not a
problem, but above it is. Even if the large file is reduced back to a very
small one, the compression still does not result anymore in a significant
reduction (e.g. when deleting data in the >30MB file to bring it back to 5MB,
the following compression result is still max. -3%).

The size of the >30 MB is mainly driven by: ~2500 data sets as rows with 50
basis data information columns plus further 150 complex calculation columns
including lookup references to around ~30 parameter tables on another sheet.
Additionally, around 30 referenced charts are part of the file plus 1 pivot
overview table for the result.

The most commonly heard resolution approach is to do it at least in Access
and not in Excel due the data amount and required
calculation/parameterization effort. BUT there is a business reason behind
why it is done this way. Hence, does anybody has a good idea how to get the
file compressed to a size ~ 5MB (that's what I reach if the basis file is
<25MB)?

I have also heard that this issue is maybe related to an 'Excel internal
compression algorithm'. Does anybody know something about this?

I really appreciate your feedback/support and would like to thank you for
your help in advance,
Thorsten

Hi,

I have a document with many pictures. I don't save the document as a ms word doc file. I save it as a webpage , It works fine but everytime I edit this file, some pictures will be replaced with the pictures i recently added. Its making me feel uncomfortable.

How can I fix this?

Thanks

Okay, I've been working on Excel for years. I really know how to do what I'm trying to do, but I think I'm missing something.

In excel 2003, to compress all the images within a workbook, you just double clicked the image, chose compress, and voila! you had it taken care of.

In 2007, they changed it up a bit. I have selected an image, gone to the Picture Tools-->Format-->Adjust-->Compress Pictures tool. Since I am trying to compress ALL images within the workbook, I am leaving the box "Apply to selected pictures only" unchecked. I choose the smallest option in the Options menu and then click "ok". Guess what...No change.

If I select EVERY image and then I DO check the "Apply to selected pictures only" box, then the compression actually takes place. Am I missing something? I am having to find an old computer every time I need to size a file down and its getting kind of ridiculous.

Damn Microsoft. Why'd they have to change a good thing and make it no better? Someone please make me eat my words.

In Excel 2010, when you export to PDF manually, the export options include this checkbox:

Code:

ISO 19005-1 compliant (PDF/A)

and under Tools you can change the Picture Compression settings.

Is there a way to access these properties from VBA?

Many thanks in advance,

Nils

When I insert pictures into an Excel spreadsheet, the pictures are 14" wide.
How do I set the size of all pictures to be inserted to be 2" so I can see
the entire picture on my screen. From there I can move, crop, resize etc..

I am embedding a picture by filling a comment box. I have a number to do in each of my 3 tables. With each picture being 2.5 MB I had to shrink the size of the pictures first. The last 2 tables worked great, the whole file size is under 1MB. But the first table I did the file saved much larger, 37 MB. I looked at the size of each of the 20 pictures I used and they all ranged between 30 - 45 kB. so I started to troubleshoot and I removed one picture at a time and resaved. The file size did not decrease until all "comments" (pictures) were deleted. Then the file was down to 37 kb. From there I would add one picture and my file would baloon to 37 MB again. I would delete the "comment" and add a different picture and it would baloon once again.
How does a file increase from 37 kB to 37 MB just by embedding a 40 kB picture?

Hi all,

I am using an excel X-Y scatter chart to present some management information, plotting points on a simple matrix. Each point has been set up as a separate series, as each one represents a different item, and I want to use the items reference as the data label.

In order to enhance the appearance, and also as a workaround for duplicate values, I had formatted the data labels to be pictures using:

Format data labels, Area fill effects, pictures - and just picked up a picture from clipart. This all worked fine, and I saved the document.

However, when I close and re-open the workbook, the pictures have become corrupt and are no longer present. I have to repeat the procedure for allocating the picture in order to get it back again.

Any ideas for workaround, or if this is a known problem?

Thanks,

Steve

Hi
I need some help in finding or developing a compressing technique, which can compress a 7 number string i.e., 11,10,1,2,10,7,5 down to 6 or 5 lossless, that would be amazing.

I already researched many compression technique; Huffman, Run-Length and LZ78 which all do well on large data sets and I only have a few numbers. If it helps by converting the numbers to binary for better compression then I what to known. I know that a solution could be impossible as we would know about it already but may be someone knows a trick to get rid of one digit, then that helps...

Hi

I can't figure this one out. I have a jpeg image in the My Pictures folder. I have a mail merge source file (excel file) and a word document I'm trying to insert the picture into using mail merge. The example on the msdn website doesn't work as this is what I'm doing below.
I've tried to refresh the field by hitting F9 but still nothing. It just comes up with a blank picture frame in my word document.

In the excel file (source file) in the "Pictures" column I put the below.

Code:

"C:\\Documents and Settings\\Username\\My Documents\\My Pictures\\testpic.jpg"

In the word document field where I want to insert the picture I put the below.

Code:

{INCLUDEPICTURE { MERGEFIELD "Pictures" } \*MERGEFORMAT\D}

I've tried with and without the \D at the end but it makes no difference.
I have also tried with and without quotation marks around "Pictures". Still no difference.

Any clues as to how I can get this to work?

Thanks so much.

Whoa! You might be asking yourselves. What does this guy really want?

I've honestly searched the Internet for I don't know how many hours, so you guys are my last chance

I would like to add pictures to my worksheet without having to resize them manually because of lengthy time factor and what more, the lines on which the pictures are placed don't adjust themselves to the size of the pictures.

My problem is that I need to make a product inventory in which there would be a picture next to the description of the product. The pictures would be 6,4 x 4,8 cm or 4,8 x 6,4 cm.

I would like to know if there's a way to format the cell so that when I drag (from the explorer) a picture to where it should go, it doesn't "float" over the line but goes into the cell and adjusts itself to the size of the cell!

Help me out guys, I really need this to work!

Thanks for your help and advice.

Hello,
My name is Eddie and this is my very first board posting, so please have mercy on me.
I am not computer proficient or savvy but normally with time and dedication I find my way around but I have hit a roadblock with the 'insert pictures feature'
I created an inventory worksheet where I store a lot of information about my stock and sales.
The problem I have is that the pictures do not stay attached to the row.
Sometimes I need to do ceratin sorts or remove certain rows in a document but the pictures do not 'move' with the row, the just stay there overlaping (overimpossing) with the previous row.
I imagine there is a command that I need to execute once I have inserted the picture from a file so that picture will become an integral part of the row and will stay with the row.
Can somebody advise on what I have to do?
Thank you in adavance!
Eddie

Good Evening everyone,

I am currently looking to figure out the best way to do some image replacements in Excel.

Basically the pictures may change every so often, and we have a root folder where all the pictures are stored.

I would like Excel to Index and Match the pictures based on the item number that we assigned each picture. Is this possible with conditional formatting or do I have to make a macro?

Example:
Picture placeholder that is 300x300 is in the excel file.
Picture Folder that has 300x300 pictures is in the same directory.
Some pictures are updated and I move them to the Picture Folder.
I now F9 or open excel, all the pictures are loaded from that folder, and are in the same position as the previous placeholder.

Is this possible, and what about be your suggestions on going about this. I am thinking something like INDEX and MATCH, but how can it match the picture. I am thinking naming all the pictures the same code, as the code on the spreadsheet. And from that, it replaces the picture.

Thanks!

I have searched several blogs and have not found a solution and hoping someone can help. Just upgraded from Excel 2002 to 2010 and when saving a file that was roughly 5.5 MB it exploded to 26 MB even when trying to recreate as a 2010 version (same size as when saving in 2002 format).

The file has several macros and copy roughly 50 charts as pictures into individual sheets since e-mail the summary and do not want to copy all of the other spread sheets. Know that the file expansion size is due to the pictures. So any suggestions when copying charts to possibly other format, compression techniques or other to get file size below 10 MB so it can be e-mailed?

Thanks for any assistance as this was a suprise.

I have a worksheet which is filled with a bunch of pictures, and
depending on the layout I have there will need to be up to 500-2,000
pictures.... maybe more.

There are only six 'different' pictures however, most are copies of a
reference picture.

I want to be able to hide all the pictures or show them depending on
the value of a checkbox in a userform. Here is the code I have
(chkQCAoverlay is a check box):

Private Sub chkQCAoverlay_Change()

On Error Resume Next
Worksheets(2).Pictures.Visible = chkQCAoverlay.Value
On Error GoTo 0

End Sub

The 'on error' is there in case there are no pictures on the worksheet.


The code works if I have a few pictures (around 30) but if I have many
more, it stops hiding the pictures. Anyone know what's going on?

I have a spreadsheet which I PDF using cutepdf, There are images in the spreadsheet that look very sharp in excel but when viewed as a pdf the graphic is low resolution?
When right clicking the graphic image and format picture there is a button for compression which seems to be checked all the time (Excel 2003).
How can This be overcome?

With the help of you guys (Thanks as always) I have built my sheet to import numerous pictures and resize them to the cell size. Obviously if I have imported a couple of hundred pictures the size of the workbook is very big. I can get over this by deleting all pictures on close and re-importing them on opening. However I wondered is there a way for excel to change the filesize of numerous pictures.
I can of course change their filesize in a picture editing program before importing but wondered if I can do this in excel as I bring them in?

The more I am getting into this the more I'm thinking there's almost nothing you can't do in excel

I'm trying to find a way of creating a code which optimises the display in the Excel 2007 workbook. What I mean by this is if the user zooms into a table for example in a worksheet, if they decide to click on the 'Optimise Display' button, it presents them with the original zoomed out view of the table.

So far, I have a module consisting of:

Code:

Sub size1()
'
' size Macro
' Macro to auto-optimise display

    Application.ScreenUpdating = False
    Application.Goto reference:="size"
    ActiveWindow.Zoom = True
    Application.Goto reference:="R1C1"
    Application.ScreenUpdating = True
End Sub

I was however given this code and I'm trying to find out how it's meant to work because it isn't at the moment.

I need to know how to create a macro which sets the spreadsheet to a certain zoom %.

I've looked throughout the forum and on the web, and while I've found good tutorials, etc. I still can't seem to get this to work.

So here's the layout:

Sheets: Config, Data, SummaryData, Pictures, Summary

I want a cell on Summary (a merged and centered cell, it consists of D11:F19 merged) to display a picture shown in Pictures!A, Pictures!C, Pictures!E, or Pictures!G based on the If-Then-Else statement in Pictures!H2.

That formula looks like this:
Code:

=IF(Config!A4=Data!B3,"Picture" & Data!B3,IF(Config!A4=Data!B4,"Picture" & Data!B4,IF(Config!A4=Data!B5,"Picture" & Data!B5,IF(Config!A4=Data!B6,"Picture" & Data!B6,IF(Config!A4=Data!B7,"Picture" & Data!B7,IF(Config!A4=Data!B8,"Picture" & Data!B8,IF(Config!A4=Data!B9,"Picture" & Data!B9)))))))

Pictures!H2 looks to Config!A4 to see which model has been selected, compares it against a list of models in Data!B and adds the word "Picture" in front of the model number.

Each picture's cell has a defined name of PictureModelNumber
I have a formula of =INDIRECT(Pictures!H2) defined as Picture

Back to Summary!D11:F19 merged... This cell is set to =Picture.

I get nothing more than 0 for Summary!D11:F19 merged.

Any ideas?[/i]

MY first post - hopefully not too difficult!

There is a space problem on our company servers.
We have many thousands of excel files with pictures in them.
I have been asked to identify non-jpeg pictures in files.

I have code that opens workbooks and loops through all pictures using the .Type property of the shape to identify them. Is there any way to identify whether the inserted picture is jpg, bmp etc?

It might seem simpler to just loop through converting all pictures to jpg, but pictures grouped with drawn objects are often messed-up quite badly in doing this.

Thanks in advance for any help

Gaj