Find & Replace in Excel 2010

[DaveL485]

I've got a grid of cells with links to other workbooks, with an IF function for error protection. There's over a thousand links per sheet over 13 sheets.
Some of the links are invalid for the time being because data isnt there yet but im trying to build the master sheet for the full year. Ive built Period 1 out of 13, and then pasted the worksheet over for period 2, and then tried to use Find & Replace (manual and VB) to change the target name-

=IF(ISERROR('C:\LINK\[Document Period-1.xls.xls]KPI Input'!K11),"-",'C:\LINK\[Document Period-1.xls.xls]KPI Input'!K11)

Period-1 needs changing to Period-2 but if I run Find & Replace or

Sub Macro1()
'
' Macro1 Macro
'

'
    Cells.Select
    Cells.Replace What:="Period-1", Replacement:="Period-2", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub

it throws up and error for every link thats not yet valid.

Is there a way of ignoring this erroring and just carrying on with the replacement? Ive also tried File>Options>When calculating this workbook and unchecking Update links to other documents with no success.

Thanks!

 

[GlennUK]

The quickest way around this is to create dummy period files ... with the right sheet names but no actual data.

 

[DaveL485]

The quickest way around this is to create dummy period files ... with the right sheet names but no actual data.

I did do that for the first one, but hesitated when I figured i'd have to create 120-odd fake workbooks

 

[DaveL485]

Sorted- I just changed the top row of the grid, copied and pasted formula only down the block and it only pops up one error box for each different workbook name (about 12) which I can live with.

Thanks!