Make worksheet run more efficient?

Bret1

Board Regular
Joined
Jun 14, 2013
Messages
99
Hi,
I use a worksheet that is mostly pics of several hundred small charts and lines with text descriptions of each. It is currently using about 460MB of memory, but the pics will increase as time goes by with updates. Are there any "tricks" I can use to help it run more efficient and use less memory, such as "grouping" the pics, renaming the pics into chronological order on the selection pane, or renaming/grouping the lines?
I know I can go up to 2GB memory, but just want to keep it running good.
Thanks!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,961
.
Overall, saving the workbook as .XLSB format will reduce the size of the workbook tremendously.

Don't store the images within the workbook. The more images you store the larger the workbook becomes, the slower it opens/closes and becomes bogged down.

Consider using only a description for the image and not include the image. Have a hyperlink where the image can be opened within the workbook. That way, only one image at a time is actually
viewed within the workbook.

Consider using only a thumbnail image stored next to the description.

Consider which type image format you will use - some formats take up less space than others.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,459
Messages
5,414,647
Members
403,540
Latest member
mmorejon1215

This Week's Hot Topics

Top