Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / May 2007



Tip: Looking for answers? Try searching our database.

Baffled

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
incognito - 27 May 2007 01:48 GMT
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>

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.