Using 4.4.1.0 for .Net.
I am generating an excel file that, after I have made a simple change to the input file, is GPFing Excel when the generated file is opened.
I have attached a zip file with the following 4 files that I hope will allow you to reproduce this :
testWorking.xls is a previous version of the file that opens OK after generation.
testGPFs.xls is a modified version of the file that when generated GPFs Excel. The only change is to row 269 on the second sheet - the range has been fixed in all the columns e.g. =SUMIF($B238:$B266, $B269,C238:C266) was changed to =SUMIF($B$238:$B$266, $B269,C$238:C$266). If I change it back the workbook generates OK.
code.txt is a simple example that I have created by "recording" the row/column insert/deletes that I am making to the file during the generation.
testOutput.xls is the file that has been generated that GPF's in case it is any use.
Thanks,
David