Unfortunatly this won't work. Spreadsheet::WriteExcel only supports references to worksheets within the same workbook. External references aren't supported.
A future version probably will support them but in the short term there are more pressing issues. :-(.
--
John.
Comment on Re: Incrementing formulas by whatever you like in Excel