Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2015, 06:14 AM
Sekerob Sekerob is offline Opening a word doc without opening all attached links/reference Windows 8 Opening a word doc without opening all attached links/reference Office 2013
Novice
 
Join Date: Jul 2015
Posts: 6
Sekerob is on a distinguished road
Default

You can get those [not being able to update] messages even though there are no broken links... searched a workbook many times, but there's none [not even in named ranges that contain a dynamic formula].
Of course, linking to files with the same name is asking for trouble, and the last warning screenshot confirms so. Would you ever open that archived copy, it will substitute links to point to itself.
One pit-fall is using certain methods of index/match with offsets to fetch data from an external book. You could end up with #N/A evaluations, subsequently followed with warning of errors.

EDIT: An example what does work, where the name\location of the file can be changed by making indirect look at a secondary field to get the file name [in text form]. Sample

=INDIRECT("'[WhateverFileName.xlsm]SheetName'!RangeCellName")
Reply With Quote
  #2  
Old 07-20-2015, 11:18 PM
Nicobisgaard Nicobisgaard is offline Opening a word doc without opening all attached links/reference Windows 7 64bit Opening a word doc without opening all attached links/reference Office 2010 64bit
Novice
Opening a word doc without opening all attached links/reference
 
Join Date: Apr 2015
Posts: 8
Nicobisgaard is on a distinguished road
Default

The last error message was defintely a mistake. I wanted to leave it out as it's simply fixable. I m working on two cases simultaniously so sometimes i forget to close files in one of the two cases.
The remaining error messages are still hard to get rid of though.

As i said initially, the problem about the File>Info>Edit Links to Files method is that i have to do it manually for every single link. And Word won't allow me to just mark everything and change it. It only alllows a limited number at a time.
That's why i was looking to see if there was a smarter way of handling it.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Template Always Opening Hobbes Word 7 09-24-2014 11:00 PM
Opening a word doc without opening all attached links/reference Need Help With Opening a Word Document PosseJohn Word VBA 1 12-06-2013 01:16 PM
Opening a word doc without opening all attached links/reference Word files not opening dogMarine Word 1 10-15-2012 11:32 AM
Opening Word XML files in IE8? RBizzle Word 0 09-13-2010 08:25 AM
Opening a word doc without opening all attached links/reference Opening word docs Bemklaver Word 1 03-31-2010 02:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 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