Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-28-2019, 01:19 PM
Dual Trace Dual Trace is offline Windows 10 Office 2010
Novice
 
Join Date: Jan 2019
Location: Beaverton, OR
Posts: 2
Dual Trace is on a distinguished road
Default Help with pasting screen shots in Excel

I intend to collect hundreds of screen shots and place them in Excel because it is very easy to scroll through them later on. I will gather around 50 per day. However after placing few tens of them, the file size gets huge and Excel displays a "Not responding" message when saving the file. After a while the message disappears and the file is saved. However I fear that I will soon reach a point when it will eventually crash.



My question is what if anything can be done to reduce the size of the images? I tried placing them first in Paint and reducing them from 100 to 50% and then adding them to Excel, but the Excel file size is only slightly smaller. So this way doesn't work.

The screen shots I collect contain numbers, so not a great deal of resolution is needed. To give you an idea a screen shot contains around 50 rows and 15 columns with numbers up to 7 digits.

I use Office 2010 and my Excel file currently reached 701Mb. I tried saving the file as a 2003 Excel file and the size went down to 35Mb, but when I work with this file it also displays the Not responding message when saving, but it only lasts few seconds and then it's saved. It will soon reach a point when it won't work anymore.

In case this can help, I use the Snipping tool to collect the screen shots I need.

Thank you,
Dual Trace
Reply With Quote
  #2  
Old 01-29-2019, 09:12 AM
Logit Logit is offline Windows 10 Office 2007
Competent Performer
 
Join Date: Jan 2017
Posts: 240
Logit is on a distinguished road
Default

Generally GIF format is smaller than JPG or other formats.

However, you are storing the images in the workbook itself. Why not change your project to save the images to a folder first. Then create a macro that will display the images one at a time. This will prevent Excel from 'freezing'.
Reply With Quote
  #3  
Old 01-29-2019, 11:45 AM
Dual Trace Dual Trace is offline Windows 10 Office 2010
Novice
 
Join Date: Jan 2019
Location: Beaverton, OR
Posts: 2
Dual Trace is on a distinguished road
Default

I use the snipping tool to grab the screen shots and then CTRL+C and CTRL+V to place them in Excel. This works pretty quickly. I do around 50 per day in maybe 20 min. If I need to first save each as a gif, this would imply many time consuming steps.
Reply With Quote
  #4  
Old 01-31-2019, 10:32 PM
jolivanes jolivanes is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 84
jolivanes will become famous soon enough
Default

If you want to save a selection to a folder you should be able to use one of these suggestions.

John Peltier at
https://www.mrexcel.com/forum/excel-...lls-jpg-2.html
Post #16

RoryA
https://www.mrexcel.com/forum/excel-...g-chart-2.html
Post #11

Stephen Bullen is mentioned also. I have used his code but that was quite a few years ago.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting from excel bflan0524 PowerPoint 0 07-13-2017 08:19 PM
Excel 2013 pasting value not formula bumbrlik Excel 1 12-20-2016 07:05 PM
Document 66MG after inserting screen shots sleake Word 0 06-07-2012 08:14 AM
Copying and pasting from Excel Lorna B Word 1 03-20-2012 11:58 PM
Blurry Screen Shots ashb Word 0 06-28-2006 01:37 PM


All times are GMT -7. The time now is 03:06 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft