• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1200
  • Last Modified:

Excel 2010 Spreadsheet Extremely Slow with Inserted Pictures

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
pwartenberg
Asked:
pwartenberg
1 Solution
 
pidecomCommented:
Try to resize and resample images to get a smaller spreadsheet file ;)
0
 
OCDanCommented:
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
 
pwartenbergAuthor Commented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
byundtCommented:
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
 
pwartenbergAuthor Commented:
Cannot Post this but found a tremendous amount of pictures that have been cut still showing up as a picture.
0
 
pwartenbergAuthor Commented:
This is an issue with Excel and embedded pictures.  maintennance will be required to fix this issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now