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 - 27 May 2007 14:27 GMT
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.
>
[quoted text clipped - 20 lines]
>
> Rudolf

Signature
------------------------------------------------------------------------
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 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto:pjones@kimbanet.com
<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>