| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find and unlink current worksheet from old worksheet
I have a worksheet I have used for years. Every time I open it up This
workbook contains links to other data sources pop up. I always choose Dont update. I would like to know how to find those links and remove them so it dose not keep asking me. I dont want it to update the links. Thank you so much for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and unlink current worksheet from old worksheet
I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm kmjmail wrote: I have a worksheet I have used for years. Every time I open it up This workbook contains links to other data sources pop up. I always choose Dont update. I would like to know how to find those links and remove them so it dose not keep asking me. I dont want it to update the links. Thank you so much for your help. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and unlink current worksheet from old worksheet
Thank you for your response but I am not sure if I can download anything to
my work computer. Do you know of any other way? Thank you. "Dave Peterson" wrote: I'd use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm kmjmail wrote: I have a worksheet I have used for years. Every time I open it up âœThis workbook contains links to other data sourcesâ pop up. I always choose Donât update. I would like to know how to find those links and remove them so it dose not keep asking me. I donât want it to update the links. Thank you so much for your help. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and unlink current worksheet from old worksheet
You may be able to find links in the worksheet (in formulas) by searching for [
or ]. Those will be part of the formula that points at the other workbook. But formulas aren't the only place where links can hide. They can be in names, charts, ..., lots of places. Bill Manville's program checks more locations than I can think of! I'd try to get special approval for this utility. kmjmail wrote: Thank you for your response but I am not sure if I can download anything to my work computer. Do you know of any other way? Thank you. "Dave Peterson" wrote: I'd use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm kmjmail wrote: I have a worksheet I have used for years. Every time I open it up âœThis workbook contains links to other data sourcesâ pop up. I always choose Donât update. I would like to know how to find those links and remove them so it dose not keep asking me. I donât want it to update the links. Thank you so much for your help. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pages in a worksheet linked, how to unlink?? | Excel Worksheet Functions | |||
| current worksheet | Excel Discussion (Misc queries) | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| Updating different worksheet with value on current worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
