LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default Excel memory and speed when inserting pictures ???

Greg,

I had something similar creating a list of all Facid's on a worksheet.
What worked (partially) is

- to resize cells so the pictures fit nicely in a cell.
- to set each picture to move and size with cells. (set this as shape
default is the fastest way)
- hide columns/rows with pictures you don't need

This prevents Excel from drawing them, and hence you could have some
speed increase

BTW I would suspect a procedure that updates the picture objects with
new picture files to work faster. I have not investigated this, but I
suspect the overhead would be less. You would need to move the
row/column of pictures leaving the screen area to the opposite side and
update their picture elements with the new pictures. The actual picture
objects would always be the same, and not change, just their image.
This would prevent Excel to constantly destroy and recreate objects.

DM Unseen

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting pictures into Excel Sheet at a particular size ToferKing Excel Discussion (Misc queries) 5 February 25th 10 07:03 PM
Speed of Excel When Inserting & Deleting Rows Gerry Excel Discussion (Misc queries) 13 March 5th 08 04:04 AM
Inserting pictures in Excel 2003 jawone48 Excel Discussion (Misc queries) 6 August 11th 07 06:17 AM
Problems inserting pictures in Excel 2002 sp-2 L.Skaggs Excel Discussion (Misc queries) 11 August 18th 05 01:14 AM
Memory Leak Excel 2003 vs 2000 using linked pictures Scriptick Excel Programming 0 April 27th 05 04:16 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"