C
ck
Hello Everyone,
We a have Excel 2000 spreadsheet that at one time was linked to another
workbook. Excel asks you if you wish to update your data with the linked
data. My question is how do I "unlink" the sheet. The current values in
the spreadsheet are what we want. The document was passed on to me for
help. I tried edit...links... but it just tries to get me to pick a
different file. Anyways we just want to unlink it. I also tried
tools...options...and chose to not autoupdate links and gives me a file not
found error and upon cancel, the spreadsheet opens. Can any guru's out
there pass on some advice. I am familar with VB and I can not find a
(links) collection or anything. I am able to retreive the path to the link
but I can not find a method to delete it. Anyways, help me out if you can.
TIA,
~ck
We a have Excel 2000 spreadsheet that at one time was linked to another
workbook. Excel asks you if you wish to update your data with the linked
data. My question is how do I "unlink" the sheet. The current values in
the spreadsheet are what we want. The document was passed on to me for
help. I tried edit...links... but it just tries to get me to pick a
different file. Anyways we just want to unlink it. I also tried
tools...options...and chose to not autoupdate links and gives me a file not
found error and upon cancel, the spreadsheet opens. Can any guru's out
there pass on some advice. I am familar with VB and I can not find a
(links) collection or anything. I am able to retreive the path to the link
but I can not find a method to delete it. Anyways, help me out if you can.
TIA,
~ck