Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-03-2014, 11:48 PM
macropod's Avatar
macropod macropod is offline Embedded Excel Forms in Word Windows 7 32bit Embedded Excel Forms in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded Excel Forms in Word Import/compile Word user forms into an Excel sheet mypouf Excel Programming 2 07-18-2014 09:34 PM
Using Embedded Links between Excel and Word Blaskowski Office 1 01-24-2014 04:37 PM
Embedded Excel in Word very slow to update delaneybob Word 0 02-11-2011 10:03 AM
Embedded Excel Forms in Word Embedded Excel functionality? markg2 Word 1 01-13-2011 02:17 PM
Embedded Excel Spreadsheet in Word Loses Ribbon amoncur Word 0 07-03-2010 09:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft