Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break Link
I have a procedure where it will format a sheet, move it to a new book and
save it. Problem is, a link is established from the original file to the saved one even if there are no formulas linking any cell. Perhaps it was due to the procedure. Question, how can I break this link automatically? Need you help. Rook |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break Link
Excel doesn't lie.
If it thinks that you have a link back to the original workbook, you do. It might not be in a formula in a cell, though. It could be in a Name. I'd get a couple of tools to help find it: Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm And Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp Once you find out where that link is, you may be able to fix it in the original workbook (if it's not required) or modify your routine to fix it in the new workbook. Rook wrote: I have a procedure where it will format a sheet, move it to a new book and save it. Problem is, a link is established from the original file to the saved one even if there are no formulas linking any cell. Perhaps it was due to the procedure. Question, how can I break this link automatically? Need you help. Rook -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
Link won't break | Excel Discussion (Misc queries) | |||
Can Not Break a Link | Excel Discussion (Misc queries) | |||
Can't break my link | Excel Discussion (Misc queries) | |||
break a link | Charts and Charting in Excel |