Topic:Breaking Links in Excel Remainpoint:0
   
PostTime:12/16/2008 2:39:40 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
4
Experience:
3
Thread:
263
Post:
954
Total online time:
3M
Joined date:
4/29/2007 2:46:00 AM
Last Visit:
12/16/2008 11:21:46 PM
Status:
Offline
Is there a way to break links in Excel while retaining the formula within that cell? In other words, if I have a Workbook called 'Book Two', and in one of those cells I have the following:

"='\\folder\[Book One.xls]Sheet1'$C$5+$D$7"

is there a quick way to change it so it simply references my current workbook, like so:

"=$C$5+$D$7"

I need to do this for lots of cells, and I'd love to figure out a way to shorten the process so I don't have to go in and manually edit the formula for each cell.
 
     
   
Gender PostTime:12/16/2008 2:40:36 PM Point:0 | Floor# 1
Lv is 1
portrait
Level:
1
Professional point:
5
Experience:
19
Thread:
290
Post:
993
Total online time:
19M
Joined date:
4/28/2007 11:08:00 PM
Last Visit:
12/17/2008 12:44:18 AM
Status:
Offline
 
     
   
Gender PostTime:12/16/2008 2:50:21 PM Point:0 | Floor# 2
Lv is 1
portrait
Level:
1
Professional point:
32
Experience:
5
Thread:
287
Post:
980
Total online time:
5M
Joined date:
4/29/2007 12:12:00 AM
Last Visit:
12/16/2008 11:58:01 PM
Status:
Offline
Bomb, Sorry, I agree, it copies OK as long as the equation does not refer to another work sheet in the originating workbook. So the Op's equations must be in another sheet and refer to Sheet1 in the original workbook.
 
     
   
Gender PostTime:12/16/2008 5:42:08 PM Point:0 | Floor# 3
Lv is 1
portrait
Level:
1
Professional point:
6
Experience:
1
Thread:
288
Post:
960
Total online time:
1M
Joined date:
4/28/2007 10:58:00 PM
Last Visit:
12/17/2008 12:46:54 AM
Status:
Offline
Not that I'm aware of.
 
     
   
Gender PostTime:12/16/2008 7:45:57 PM Point:0 | Floor# 4
Lv is 1
portrait
Level:
1
Professional point:
48
Experience:
8
Thread:
292
Post:
962
Total online time:
8M
Joined date:
4/28/2007 11:08:00 PM
Last Visit:
12/17/2008 12:44:40 AM
Status:
Offline
Thanks...I meant to try that but I completely forgot about it...

I should've mentioned that I've copied these cells from another workbook...which is the reason they all are linked to another workbook. To avoid this mess altogether, is there a way to paste the formulas in the new workbook without automatically linking to the workbook from which the formulas were originally copied? Was there an option in "paste special" that I may have missed?
 
     
   
Gender PostTime:12/16/2008 10:25:27 PM Point:0 | Floor# 5
Lv is 1
portrait
Level:
1
Professional point:
46
Experience:
6
Thread:
265
Post:
966
Total online time:
6M
Joined date:
4/29/2007 12:00:00 AM
Last Visit:
12/17/2008 12:21:04 AM
Status:
Offline
Paste Special>Formulas just did it for me.
 
     
   
Gender PostTime:12/17/2008 12:06:17 AM Point:0 | Floor# 6
Lv is 1
portrait
Level:
1
Professional point:
17
Experience:
7
Thread:
282
Post:
954
Total online time:
7M
Joined date:
4/28/2007 11:52:00 PM
Last Visit:
12/17/2008 12:05:13 AM
Status:
Offline
Doesn't do it for me, OBP.
 
     
1

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search