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.

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.

we can have it. but how do we disable the refresh button after the first
refresh?

"Jacob Skaria" wrote:

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.

You can have the last updated date stored in a cell' and check that in
Workbook open. If the date is different enable or display the refresh button.
Once refreshed the button can be disabled
--
If this post helps click Yes
---------------
Jacob Skaria


"murali velaga" wrote:

we can have it. but how do we disable the refresh button after the first
refresh?

"Jacob Skaria" wrote:

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.

Can u share the code to enable/disable the refresh button (which is in the
menuitem 'Data') in excel.

"Jacob Skaria" wrote:

You can have the last updated date stored in a cell' and check that in
Workbook open. If the date is different enable or display the refresh button.
Once refreshed the button can be disabled
--
If this post helps click Yes
---------------
Jacob Skaria


"murali velaga" wrote:

we can have it. but how do we disable the refresh button after the first
refresh?

"Jacob Skaria" wrote:

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.

Application.CommandBars("Data").Controls("<menunam e").Enabled = False
--
If this post helps click Yes
---------------
Jacob Skaria


"murali velaga" wrote:


Can u share the code to enable/disable the refresh button (which is in the
menuitem 'Data') in excel.

"Jacob Skaria" wrote:

You can have the last updated date stored in a cell' and check that in
Workbook open. If the date is different enable or display the refresh button.
Once refreshed the button can be disabled
--
If this post helps click Yes
---------------
Jacob Skaria


"murali velaga" wrote:

we can have it. but how do we disable the refresh button after the first
refresh?

"Jacob Skaria" wrote:

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.