Baffled

[incognito]

I am baffled.

I had created an Excel spreadsheet with inventory items with cells
containing links to actual pictures of the item, like this:

Paintngs_Antq/Invntry070226_31.jpg <Paintngs_Antq/Invntry070226_31.jpg>

After doing other things in that same spreadsheet (coloring certain cells,
for example) saving the spreadsheet and reopen it a few days later, that
link was broken!

When I cleared the cell in question and rebuilding the link in Excel with
command-K to the particular picture at the same location, in other words
exactly the same link syntax, the link works again.

I seem to miss something very fundamental in linking objects from within an
office document to an external file. I am wondering where is the breakdown
of my Œmental link¹?

Can anybody help? (I am working with an MacMini Intel core duo, MacOSX
10.4.9 and lots of memory/memories). Most important: How can I prevent
this to happen in the future?

Rudolf

 

[Phillip Jones]

If this spreadsheet has been transferred to a website the pictures; the
pictures must be upload to same location as the spreadsheet (or html File).

Also when inserting pictures try setting "save a copy of the picture
with the document". It makes the file larger but the picture is then
embedded within the file.

I am baffled.

I had created an Excel spreadsheet with inventory items with cells
containing links to actual pictures of the item, like this:

Paintngs_Antq/Invntry070226_31.jpg <Paintngs_Antq/Invntry070226_31.jpg>

After doing other things in that same spreadsheet (coloring certain
cells, for example) saving the spreadsheet and reopen it a few days
later, that link was broken!

When I cleared the cell in question and rebuilding the link in Excel
with command-K to the particular picture at the same location, in other
words exactly the same link syntax, the link works again.

I seem to miss something very fundamental in linking objects from within
an office document to an external file. I am wondering where is the
breakdown of my ‘mental link’?

Can anybody help? (I am working with an MacMini Intel core duo, MacOSX
10.4.9 and lots of memory/memories). Most important: How can I prevent
this to happen in the future?

Rudolf

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>