Data caching in Excel 2007

[dhruvan]

Hi,
I am trying to cache data in excel sheets and for that I referred to the below msdn link...
http://msdn2.microsoft.com/en-us/lib...f3(VS.80).aspx

I got a piece of code from there which caches a dataset. I tried doing that, but it is throwing a null reference exception on the "If Not (Me.IsCached("dataSet1")) Then" line.

Has anybody been able to use that code. If so, please let me know as to what could be going wrong. If somebody has any better ideas on how to cache data in excel sheets, please let me know that also.

Thanks,
Dhruvan.