Cant we have a hidden sheet with data populated on refresh..

If this post helps click Yes
---------------
Jacob Skaria


"murali velaga" wrote:

I have to create an excel report where i should have a connection string in
the report so that users can refresh the report once a day and after first
refresh the report should go offline but the report should show up the data
based on the filter changes . Basically i need to use caching technique .
Please help me in this.