View Single Post
 
Old 08-03-2014, 11:48 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your updated attachment, though, still has 17 separate LINK fields. You can see these simply by pressing Alt-F9 to toggle the field code display, then scrolling though the document below 'QUOTATION PROPOSAL'.

But there are some real oddities about these fields:
• they're LINK fields purporting to be Excel links (viz. Excel.Sheet.8)
• all point to a document (Minor Quote Template - Arran Knox.doc), not to an Excel workbook;
• despite pointing to a document reference what appears to be worksheet addresses (e.g. Calculation Schedule!R8C9:R8C10); and
• some fields have the filepath (\\\\COG\\CCS FM\\Minor Quote Templates\\) while others lack - so the LINK field substitutes the current document path.

It's almost as if someone (Arran Knox?) has tried to create a set of links to an Excel workbook embedded in another document, rather than to an Excel workbook on disc. I think someone has some serious repair work to do, so that the required links all point to the correct target - an external Excel workbook - using a fully-qualified path.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote