Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-10-2007, 12:28 PM   #1
ecuevas
Registered User
 
Join Date: Jun 2007
Location: Plainfield,IL,USA
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
ecuevas is on a distinguished road
Unhappy Inserting Pictures into Excel File causing huge increase in file size

Hi, we're working with a file in Excel where we are having people insert pictures into the spreadsheet. The spreadsheet with no pictures is 2.3 MB. The picture is 730 KB. But when it is inserted into the worksheet the file becomes 24 MB. If I add the picture again it goes up to 45.8 MB. We used the compress picture option in the toolbar but that only took it down to 23.9 MB for a file with a single picture. We need to E-Mail the worksheet but we can't E-Mail anything larger than 22 MB. Why is it doing this and how can we make the file smaller?


Last edited by ecuevas; 07-10-2007 at 12:34 PM.
ecuevas is offline   Reply With Quote
Old 07-10-2007, 12:40 PM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,825 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
I know that if you use the .png (Portable Network Graphics) format, it will reduce the size drastically.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 07-10-2007, 12:43 PM   #3
ecuevas
Registered User
 
Join Date: Jun 2007
Location: Plainfield,IL,USA
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
ecuevas is on a distinguished road
We have a button that prompts you for a picture. The picture is then added to a box and resized to fit the box. It won't allow us to enter a .png file.


Last edited by ecuevas; 07-10-2007 at 12:55 PM.
ecuevas is offline   Reply With Quote
Old 07-11-2007, 02:03 AM   #4
unmarkedhelicopter
Registered User
 
unmarkedhelicopter's Avatar
 
Join Date: Apr 2007
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
unmarkedhelicopter is on a distinguished road
I believe that whatever picture you add to an Excel File (or Word Doc for that matter) it is stored as the same internal format (unfortunately it's a .bmp i.e. uncompressed).
This is a common mistake with people with fancy cameras, they think (because they can) they should insert a 10M pixel image, this is rarely the case. Think about it, if your image is part of a report and you print it off and the image is 2 inches by 3 inches then even at 300 dpi (what ALL commercial photo printing labs print at) you'd only need 600 x 900 pixels i.e. 1/5 MP not 10 MP. So reducing the image size should be your first step, your second should be as bob suggests to use the best compression you can for the image as despite what I said earlier the document also stores the original (more file bloat), then as you say use the compress ALL images option (though if you've done as I've said you probably won't get much out of this).
If you DO NEED to include 10MP images then you are doing things wrong.
What you'd need to do is employ a developer to write something that will open the 10MP image (that was sent with the file, but not in it) in either a common desktop app or in a form to display the picture.

Edit : I often cheat and instead of using 300dpi images I'll use 150dpi and thus quarter the file size.
__________________
The Rotors have Stopped ! ... Is that a bad thing ?
2 + 2 = 9, My Arithmetic is Mental

Last edited by unmarkedhelicopter; 07-11-2007 at 02:12 AM.
unmarkedhelicopter is offline   Reply With Quote
Old 07-11-2007, 06:29 AM   #5
ecuevas
Registered User
 
Join Date: Jun 2007
Location: Plainfield,IL,USA
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
ecuevas is on a distinguished road
I figured out a solution to my problem. I just used the insert picture button from the picture toolbar instead of using the button that I made. This brings down the size to about 3 MB. The problem I have now is that I have to resize the image manually. Is there a way to make the image change to a certain size automatically when it opens?
ecuevas is offline   Reply With Quote
Old 07-11-2007, 06:48 AM   #6
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,825 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Quote:
Originally Posted by unmarkedhelicopter View Post
I believe that whatever picture you add to an Excel File (or Word Doc for that matter) it is stored as the same internal format (unfortunately it's a .bmp i.e. uncompressed).
I'm not convinced about that because of specific experiences I've had. When I started my last job there was a manual that several people had created using screenshots. They would do the typical, "hit the PrtScn button" and then paste into the document. Now, THAT is definitely using the largest size possible. Then, if I created png files of those same screenshots before inserting, the size would be many, many Kilobytes less.

You can run a quick test, too. Take a bmp file and convert it to png. Then, open a new .doc file and insert one of the pics into it and save it. Then, create another new .doc file and insert the other one and save it. Check the file sizes. I just did the same test with a 6"x3" screen capture saved from SnagIt and saved the same pic as two different types and then inserted each into a separate document. Just with one pic there was 4Kb difference.

The interesting thing is that the Word documents that I inserted the pics in were:

53 KB - with BMP
47 KB - with PNG

And the original sizes of the image files before inserting were:
BMP - 947 KB
PNG - 30 KB

So Word is doing something to it as well when you use the Insert > Picture > From File to compress it as well.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 07-11-2007, 12:41 PM   #7
unmarkedhelicopter
Registered User
 
unmarkedhelicopter's Avatar
 
Join Date: Apr 2007
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
unmarkedhelicopter is on a distinguished road
Hmm
That's interesting ... I'd like to do a full series of experiments but ... the time it would take ... Does anyone want to volunteer ?

__________________
The Rotors have Stopped ! ... Is that a bad thing ?
2 + 2 = 9, My Arithmetic is Mental
unmarkedhelicopter is offline   Reply With Quote
Old 03-23-2019, 10:11 AM   #8
hotwire
Newly Registered User
 
Join Date: Mar 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
hotwire is on a distinguished road
Question Re: Inserting Pictures into Excel File causing huge increase in file size

Hello, I know this is a very old thread but I came across it by searching for an answer to MS Excel flaw on enlarging a file on a single image..

It appears that this forum is more dedicated to MS Access, however, It's the closest I have come after doing searches for this issue with excel file size increasing with images..

I have a similar situation, but what blows my mind is that I am only using ONE image as a background but every time a new sheet is created (With The Same Image Reference), Excel continues to make the file larger although each sheet is referencing the same image file! This Is crazy.. And I can't seem to find a good solution to this flaw as to why each sheet makes the file larger although they reference the same image path? To me this should be an Excel Bug or flaw.

Thanks for any info regarding this issue.

PS. The only workaround I have used is to have each sheet vba access the image path for the background.. This jeeps the file size only as large as the image size plus any additional data the user adds.

hotwire

hotwire is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
TransferText import macro zogpound Macros 6 09-12-2007 11:32 AM
What causes a database file size to bloat (file size increase)? Cosmos75 General 13 08-12-2005 02:37 PM
Huge Performance Increase with MDE or Other File Extension tpolansk General 3 07-27-2003 11:55 AM
Importing an Excel file on weekly basis to Access w/o losing data hahnsm Modules & VBA 0 06-18-2003 08:51 AM
Convert Excel file into Text file polina Modules & VBA 1 02-07-2003 09:44 AM




All times are GMT -8. The time now is 04:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World