I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

one way to find formulas with external references is to use find and search
for "[" which is used in the external reference formula

" wrote:

I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

Maybe Bill Manville's FindLink program can help you find the problem link(s):
http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

--

Dave Peterson

Thanks, I have tried the search for "[" with no luck, I also tried
the findlink program with no luck. What about data imported from the
web? is there a way to determine any such import? or what if the
import is coming from a named range? (i have many named ranges, some
of which i am not sure what they do since other people have
contributed to the workbook).

Any further thoughts?



On Jul 31, 10:43 am, Dave Peterson wrote:
Maybe Bill Manville's FindLink program can help you find the problem link(s):http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

--

Dave Peterson

Actually, that was it... There was a reference in a named range (or
rather a #ref!)

They were probably reminants of a past functions which are no longer
needed.

Thanks for the help.

On Jul 31, 3:37 pm, " wrote:
Thanks, I have tried the search for "[" with no luck, I also tried
the findlink program with no luck. What about data imported from the
web? is there a way to determine any such import? or what if the
import is coming from a named range? (i have many named ranges, some
of which i am not sure what they do since other people have
contributed to the workbook).

Any further thoughts?

On Jul 31, 10:43 am, Dave Peterson wrote:



Maybe Bill Manville's FindLink program can help you find the problem link(s):http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Didn't Bill Manville's program find that?

" wrote:

Actually, that was it... There was a reference in a named range (or
rather a #ref!)

They were probably reminants of a past functions which are no longer
needed.

Thanks for the help.

On Jul 31, 3:37 pm, " wrote:
Thanks, I have tried the search for "[" with no luck, I also tried
the findlink program with no luck. What about data imported from the
web? is there a way to determine any such import? or what if the
import is coming from a named range? (i have many named ranges, some
of which i am not sure what they do since other people have
contributed to the workbook).

Any further thoughts?

On Jul 31, 10:43 am, Dave Peterson wrote:



Maybe Bill Manville's FindLink program can help you find the problem link(s):http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I have a workbook that prompts me about external data everytime i save
it. There should be no external data. How do I find and remove these
sources?

It may be the result of moving sheets from one workbook to another, I
have attempted to update all formulas to reference only sources in the
current workbook. I just find and replaced [old workbook] with
nothing. I still get the pesky prompt.

thanks

-Josh

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson