I consolidate management accounts on a monthly basis. Each month's management
accounts are saved in one folder. In the following month I receive new
management accounts and I save them in a new folder. Thereafter, I copy the
consolidated management accounts from the prior month "linked document" into
the new month's folder.

I then open the consolidated document and update links - Edit/Links/Change
source and click on the new source workbook. When click on the new source
workbook sometimes nothing happens and it some instances I get a message that
the formula is too long.

Regards

Thami