Created attachment 103639 [details] Example of problem Attached is a sample spreadsheet. It contains a snippet of data and forecasts against it. The forecast columns contain the formula. 1. Insert a row by right clicking and selecting 'add a row above' 2. In versions 4.2 and greater it extends the cell references and creates Err Details are inside the sample sheet.