Live Office XI 3.1 "Unknowned" Error

[Former Member]

We are trying to use Live Office XI 3.1 (latest SP and FP) in Excel 2007 to create a single column dataset with approx. 250,000 rows. The file size for this dataset is approx. 12mb and in the CMC we have set the "Maximum Character Stream Size" to 50mb in the Webi Processing Server settings. The process returns a very generic error message stating "An error occurred when refreshing". When we click the "Show Details" button, we get the "unknowned error" message. We have successfully run a much smaller dataset from the same universe.

Any ideas why the larger dataset would return this error?

Thanks.

[Former Member]

Figured out the answer to this. When bringing in large amounts of data into Excel 2007 from LO, you have to force Excel out of Compatibility Mode when it starts up. If not, Excel 2007 starts up as Excel 2003 and you're limited in the number of rows a LO query can return.

Thanks.

[denis_konovalov]

Increase Max binary and Max Character sizes to 100.

On the other hand - why would you want to import that much data into Excel ?