Make worksheet run more efficient?

Bret1

Board Regular
Joined
Jun 14, 2013
Messages
199
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!
 

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
.
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.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top