Instead of find / replace... try these 2 options.


1) Go to Edit-Links and select the file you want to replace, click
change source and select the new file
2) Open both files (the old "mother file" and the new one) then try
the file / replace. by opening the files, the full path is no longer
displayed in the formula.

On Jun 2, 7:17 am, AB3 wrote:
Hi,

I've taken over a project that consists of a number of Excel spreadsheets
that produce graphs from the data in a 'mother' spreadsheet (there are a lot
of graphs and a lot of data!).

In order to update the data in the graphs spreadsheets, I have to 'Find and
Replace' part of the formulas - ie changing the filepath so it points at a
different mother file. However, I keep getting a "Formula is too long" error
message - is there any way round this?

I've tried moving the files so they had a shorter file path, but it is still
too long (there are a lot of calculations). Changing the name of the new
mother file doesn't help either, as it's the old name that's too long.

Would be very grateful if somebody could help me with this as there are far
too many of them to change by hand!

Thanks and regards,

AB3