Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find and replace all
I use Office 2003 and I tried to do the following (and failed): I work in a spreadsheet with 1663 links to other resources: ='C:\Documents and Settings\Pinnacle\Desktop\Pinnacle Spreadsheet 1.0\24 Hour Mobility\[AlfaGranite.xls]SENNBV'!$O$4 Now I want to replace this whole directory link and I want to change all the 1663 links from the long one (see above) to this one='[AlfaGranite.xls]SENNBV'!$O$4 But I will not replace ='C:\Documents and Settings\Pinnacle\Desktop\Pinnacle Spreadsheet 1.0\24 Hour Mobility\ to '[AlfaGranite.xls]SENNBV'!$O$4 The cells are not protected nor locked, I don't understand why I won't simple replace the codes. What am I doing wrong here? -- janfolmer ------------------------------------------------------------------------ janfolmer's Profile: http://www.excelforum.com/member.php...o&userid=26297 View this thread: http://www.excelforum.com/showthread...hreadid=398609 |
#2
|
|||
|
|||
This
='[AlfaGranite.xls]SENNBV'!$O$4 will refer to an open workbook. Do you have a workbook named alfagranite.xls open when you do the replace? What happens when you try the replace--you didn't give many specifics? And did you try Edit|links|change source? janfolmer wrote: I use Office 2003 and I tried to do the following (and failed): I work in a spreadsheet with 1663 links to other resources: ='C:\Documents and Settings\Pinnacle\Desktop\Pinnacle Spreadsheet 1.0\24 Hour Mobility\[AlfaGranite.xls]SENNBV'!$O$4 Now I want to replace this whole directory link and I want to change all the 1663 links from the long one (see above) to this one='[AlfaGranite.xls]SENNBV'!$O$4 But I will not replace ='C:\Documents and Settings\Pinnacle\Desktop\Pinnacle Spreadsheet 1.0\24 Hour Mobility\ to '[AlfaGranite.xls]SENNBV'!$O$4 The cells are not protected nor locked, I don't understand why I won't simple replace the codes. What am I doing wrong here? -- janfolmer ------------------------------------------------------------------------ janfolmer's Profile: http://www.excelforum.com/member.php...o&userid=26297 View this thread: http://www.excelforum.com/showthread...hreadid=398609 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
find and replace | Excel Discussion (Misc queries) | |||
Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
VB Find and Replace | Excel Worksheet Functions |