Hello, First I'd like to say thank you to John for writing WriteExcel, it's made me a wonder-boy here at my datacenter. I've used WriteExcel quite extensively, but cannot figure out a workaround for array formulas. I know that WriteExcelXML supports array formulas, but it doesn't support other methods such as data_validation and image insertion, which I also need for deliverable XLS reports to my customer. Any update on supporting array formulas in WriteExcel in the future? Or do you know of a workaround? I've fudged around a little with mixing both WriteExcel and WriteExcelXML but wasn't successful. In the meantime, I'm just inserting a # sign before the formula and adding a cell comment which instruct the user to remove the leading # and hit return. This allows the formula to compute once the document is open in Windows. It works, but it's ugly. thnx a bunch. bob