View Single Post
 
Old 07-20-2015, 06:14 AM
Sekerob Sekerob is offline Windows 8 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