ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Do you want to update" msg (https://www.excelbanter.com/excel-discussion-misc-queries/264573-do-you-want-update-msg.html)

nadine

"Do you want to update" msg
 
I have a workbook that asks me this when I open it. I cannot find the link
that is pointing to another workbook. Does anyone know an easy way to find
this? Thanks so much.


Dave Peterson

"Do you want to update" msg
 
I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Nadine wrote:

I have a workbook that asks me this when I open it. I cannot find the link
that is pointing to another workbook. Does anyone know an easy way to find
this? Thanks so much.


--

Dave Peterson

nadine

"Do you want to update" msg
 
Thanks so much!!!

"FSt1" wrote:

hi
do a find. links are usually formulas that have brackets something like
=[MyBook1.xls]Sheet1!$A$1
so in the find box search for either a [ or ].
in the within box, check workbook
in the look in box, check formulas
click find all.

also you might try....
03 or later...on the menu bareditlinks. you cant' delete the link and i
don't think it displays but you can choose to show the message or not. click
startup prompt.
07.
data tabedit links.


"Nadine" wrote:

I have a workbook that asks me this when I open it. I cannot find the link
that is pointing to another workbook. Does anyone know an easy way to find
this? Thanks so much.


FSt1

"Do you want to update" msg
 
hi
do a find. links are usually formulas that have brackets something like
=[MyBook1.xls]Sheet1!$A$1
so in the find box search for either a [ or ].
in the within box, check workbook
in the look in box, check formulas
click find all.

also you might try....
03 or later...on the menu bareditlinks. you cant' delete the link and i
don't think it displays but you can choose to show the message or not. click
startup prompt.
07.
data tabedit links.


"Nadine" wrote:

I have a workbook that asks me this when I open it. I cannot find the link
that is pointing to another workbook. Does anyone know an easy way to find
this? Thanks so much.



All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com