Solved

Excel 2010 Spreadsheet Extremely Slow with Inserted Pictures

Posted on 2012-03-30
6
323 Views
Last Modified: 2012-08-13
We have a product matrix that we setup in Excel which used to work well into we added small pictures for each of our items.  The spreadsheet has grown from about 200K to 3-4MB but the issue is with peformance in that the spreadsheet is almost unusable.  This might not be the best fit for this application but if anyone has experience in dealing with this or suggestions on how we can still have the pictures in Excel but still be able to navigate the spreadhsheet.
0
Comment
Question by:pwartenberg
6 Comments
 

Expert Comment

by:pidecom
ID: 37789261
Try to resize and resample images to get a smaller spreadsheet file ;)
0
 
LVL 9

Expert Comment

by:OCDan
ID: 37789264
You have probably already done this, but click on any picture in there and on the 'Format' section of picture tools pick 'Compress Pictures' click options and then choose email 96ppi:

Compress Pics
0
 

Author Comment

by:pwartenberg
ID: 37789271
We have already tried that.  The images are actually very small to start with since we have sized them to fit into a smaller cell.  There is quite a few of them though.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 81

Expert Comment

by:byundt
ID: 37789797
Are the pictures static or do they change according to cell values? I'd be surprised if static pictures affected recalculation time at all. But there are other factors, such as overuse of volatile functions like INDIRECT or OFFSET that can cause such a problem.

Are you able to post the workbook? If it is proprietary, could you post a workbook that contains 10 rows of content using made-up data and pictures?
0
 

Accepted Solution

by:
pwartenberg earned 0 total points
ID: 37802622
Cannot Post this but found a tremendous amount of pictures that have been cut still showing up as a picture.
0
 

Author Closing Comment

by:pwartenberg
ID: 37820882
This is an issue with Excel and embedded pictures.  maintennance will be required to fix this issue
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question