I have a excel spreadsheet which is populated from the data thru OLE from mainframe. The spreadsheet contains 40 coulmns atleast 50% of which have fromula's. The number of rows returned are around 6000+. It takes almost 10 minutes to populate the spreadsheet. I need to sped it up. Using tools - option- calculation-manual is not a option as I believe that impact all the excel spreadsheet on the server.
Can any one suggest some thing? the formula's mostly uses the Excel's native funtions which includes vlookup and arithmatic/logical functions.