| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I zap all links in one go?
I have a spreadsheet with many links to other spreadsheets in various unconnected cells. Is there a quick way to paste-special-value these links rather than doing it cell by cell (there are other formulas in between that I want to keep)? -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=563747 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I zap all links in one go?
From top menu go to Edit | Links. The pop up window shows a list of all
files you haves linked to. Select each file and click the Break Link button. This works well if you have only one or a few files linked. However, if every cell is linked to a different file, it's probably just as much work as copy | paste special | values for each individual cell. -Simon "germullen" wrote: I have a spreadsheet with many links to other spreadsheets in various unconnected cells. Is there a quick way to paste-special-value these links rather than doing it cell by cell (there are other formulas in between that I want to keep)? -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=563747 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I zap all links in one go?
Thanks Simon, I never thought of looking in the menu !! I've opened the window, but there's no 'Break links' button. I have Excel 2000 - is that on a later version? -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=563747 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I zap all links in one go?
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm There's lots of options in that utility. germullen wrote: I have a spreadsheet with many links to other spreadsheets in various unconnected cells. Is there a quick way to paste-special-value these links rather than doing it cell by cell (there are other formulas in between that I want to keep)? -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=563747 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I zap all links in one go?
yeah, that works, thanks for the -link-. -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=563747 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
| options to update automatic links | Excel Worksheet Functions | |||
| Prompt to update links | Links and Linking in Excel | |||
| Deleting links to other spreadsheets | Excel Worksheet Functions | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
