Find and replace all

[janfolmer]

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 Spreadshee
1.0\24 Hour Mobility\[AlfaGranite.xls]SENNBV'!$O$4

Now I want to replace this whole directory link and I want to chang
all the 1663 links from the long one (see above) to thi
one='[AlfaGranite.xls]SENNBV'!$O$4

But I will not replace ='C:\Documents an
Settings\Pinnacle\Desktop\Pinnacle Spreadsheet 1.0\24 Hour Mobility\ t
'[AlfaGranite.xls]SENNBV'!$O$4

The cells are not protected nor locked, I don't understand why I won'
simple replace the codes.
What am I doing wrong here

 

[Dave Peterson]

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?

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?