caching in excel

[murali velaga]

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.

 

[Jacob Skaria]

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

If this post helps click Yes

 

[murali velaga]

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

 

[Jacob Skaria]

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

 

[murali velaga]

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

 

[Jacob Skaria]

Application.CommandBars("Data").Controls("<menuname>").Enabled = False