Hi,

I am currently working on a number of spreadsheets each containing a number
of worksheets. I have created one 'consolidated' spreadsheet in which I have
added up all the data from all spreadsheets so that it shows overall totals.
This works fine. However, as I am doing some work at home and some at work,
whenever I copy and paste the files from one location to another the formulas
in the consolidated spreadsheet become too long for Excel to handle. This is
because the formula includes the full path name of the spreadsheet rather
than just the spreadsheet name. This happens every time I move the
spreadsheets from my C: drive at home to my network drive at work.

Does anyone know if there is any way around this problem as I'm currently
having to re-enter all forumlas whenever I transfer work which is becoming
far too time consuming!

Any help gratefully appreciated.

R