ExcelBanter - View Single Post

Howard Kaikow

"Anna Rajan" <Anna wrote in message
...
To save an excel file of about 32.602 MB size it takes 14hrs45min.
Currently it is implemented using threads in VC++.
Here a stingray studio function (OnSaveDocument) is used to save the file
in
excel format.
Working on Visual Studio 2003
How can it be reduced to about 4 hrs??
Here before saving the data to the Excel file, the values are populated to
a
grid after calculation.
To place the value in the grid we call CGXGridCoSetValueRange().
Now to improve the performance, I changed it to CGXData:StoreValueRowCol()
to place the values.
Also I tried using LockUpdate() along with this.

But all these did not have any effect.

Please help

Make sure that no formulae are being updated when you Save the file.