using jpegs in worksheets

[jerry]

Hello,

I work at a museum, and tend to use jpegs a lot in
worksheets. I have been copying them from an image viewer
and pasting them into cells, after manually expanding the
cell to fit the image.
The result is a spreadsheet that is very helpful, but is
also extremely large. I have one for a current exhibition
that is something like 50-60 megs.
I believe there is a way to put an image LINK into a cell
instead of pasting the image in it, thereby saving a great
deal of drive space and time (the huge worksheets I've
been making take upwards of 5 minutes to open on even a
good computer.)
Can anyone tell me how I might do this image linking in
cells?
Thank you in advance.

 

[Frank Kabel]

Hi
maybe you mean to insert the file as 'Symbol' you can check this option
if you use 'Insert - Object - From file'

 

[JE McGimpsey]

My advice would be to forget XL and use a database program. Access may
do an adequate job, but there are better database apps, including some
that are designed for catalogs.