Hi Everyone,

I use a very large Workbook at work and there are currently about 20 to 30 Spreadsheets in the Workbook. From time to time I have to insert new workbook and then link this via formulae to some of the other Spreadsheets. What I would like to know, is there an easy less time consuming way i.e. a way I can create several formulae linking one Spreadsheet to another at one go? TIA