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