Find and replace in formulas containing Structured References

[oblix]

Hi there
I have copied a sheet and want find and replace "Table3" with "Table 4" in all formulas but excel does not want me to do this.
Is there something I'm missing here?
Or is there another way because I really don't want to change these hundreds of formulas manually?
Thank you in advance for assitance

 

[Rick Rothstein]

Show us one of the original formulas with "Table3" in it so we can see how that is being used within the formula.

 

[oblix]

Thank you Rick
Here is one with Table38 I have to change to Table39
=IF(G10=0,'PRICE COMPARISSON'!M10,SUMIFS(Table38[[Price]:[Price]],Table38[[Item]:[Item]],Table364894[[RATION ITEM]:[RATION ITEM]],Table38[[Date]:[Date]],G10))

 

[oblix]

resolved
You have to choose the whole reference of the table
eg Table38[[Price]:[Price]]