Re: External Reference

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 02/07/05 

Date: Mon, 07 Feb 2005 06:53:57 -0700

You can use Edit/Find to look for "[" in formulas, and look in the
Insert/Name/Define listbox to see if a defined name refers to an
external file.

If you can't find it that way, you might try running Bill Manville's
FinkLink add-in, which you can download from

    http://bmsltd.ie/MVP/Default.htm

In article <FCFBC23F-FFC7-4CE2-807E-59F960638CED@microsoft.com>,
 "Iain" <Iain@discussions.microsoft.com> wrote:

> When I open a particular spreadsheet, the "Do you want to update External
> References...?" box appears, however I cannot locate the cells that refer to
> the external worksheets.
>
> I have tried a find on the file names listed in the links box, however there
> is no result.
>
> Is there a way to find the cells that refer to another file in Excel 2000?

Relevant Pages

  • C++: Getting Type of a Construct
    ... be as consistent as possible in type use. ... I do not have the luxury of ... object defined in an external file? ... Because of doing that, whenever I refer to S_addr, I have to do it the ...
    (alt.comp.lang.learn.c-cpp)
  • ipfw
    ... i want to know if it is possibile in my firewall.conf refer to an external file where for example i indicate my source ip or/and my destination ip of my rules. ...
    (freebsd-net)
  • Re: pasting or moving formula cells without updating formulas
    ... > I have a flat spreadsheet with a results page at the end. ... > values in said cells. ... > refer to different cells which bear the same spatial relationship to the ... $A1 tells Excel you always want to refer to column A. ...
    (microsoft.public.excel.misc)
  • Re: Unexpected Python Behavior
    ... interest in having a function refer to its own attributes. ... which exposes a _make_cell function to Python. ... outer function needed for the closure, and do an 'exec' on the resulting ... while exposing the ability to make cells doesn't ...
    (comp.lang.python)
  • Re: Make Sheets.(Range 1) = Sheets.(Range 2)
    ... characters before Cells. ... If there is a period before the word 'Cells', it will refer to the sheet specified in the With statement. ... it will refer to the ActiveSheet. ...
    (microsoft.public.excel.programming)