- Finding an external reference on a sheet
- Posted by rmellison on October 21st, 2005
I have a workbook which contains many copied sheets from other workbooks. I
have editted all of the formula so that they link only to sheets within the
workbook and not to external worksheets. However, every time I load the file
I get XL telling me that 'I have links to other workbooks, would I like to
update them?' This isn't really a problem, I just click no and get on with
it. The annoying thing is that I cannot find an external reference anywhere
on any of the sheets.
I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd expect
to find in an external link. I've also checked all the source data on my
charts for external references and not found any. For my own sanity and peace
of mind, can anyone suggest a way to quickly find an external reference???
Many thanks.
- Posted by Pegasus \(MVP\) on October 21st, 2005
Have you considered posting this question in an Excel newsgroup?
"rmellison" <rmellison@discussions.microsoft.com> wrote in message
news:6469A187-40B6-4720-B38A-09B1FB710079@microsoft.com...
> I have a workbook which contains many copied sheets from other workbooks.
I
> have editted all of the formula so that they link only to sheets within
the
> workbook and not to external worksheets. However, every time I load the
file
> I get XL telling me that 'I have links to other workbooks, would I like to
> update them?' This isn't really a problem, I just click no and get on with
> it. The annoying thing is that I cannot find an external reference
anywhere
> on any of the sheets.
>
> I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd
expect
> to find in an external link. I've also checked all the source data on my
> charts for external references and not found any. For my own sanity and
peace
> of mind, can anyone suggest a way to quickly find an external reference???
>
> Many thanks.
- Posted by rmellison on October 21st, 2005
Ooops! Thought I was in the XL workgroup. Been flitting between so many
different ones recently....
"Pegasus (MVP)" wrote:
> Have you considered posting this question in an Excel newsgroup?
>
>
> "rmellison" <rmellison@discussions.microsoft.com> wrote in message
> news:6469A187-40B6-4720-B38A-09B1FB710079@microsoft.com...
> > I have a workbook which contains many copied sheets from other workbooks.
> I
> > have editted all of the formula so that they link only to sheets within
> the
> > workbook and not to external worksheets. However, every time I load the
> file
> > I get XL telling me that 'I have links to other workbooks, would I like to
> > update them?' This isn't really a problem, I just click no and get on with
> > it. The annoying thing is that I cannot find an external reference
> anywhere
> > on any of the sheets.
> >
> > I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd
> expect
> > to find in an external link. I've also checked all the source data on my
> > charts for external references and not found any. For my own sanity and
> peace
> > of mind, can anyone suggest a way to quickly find an external reference???
> >
> > Many thanks.
>
>
>
