Check box selection...

[rajuganapathy]

Hi Team,

I have a reports contains more than 50 sheets, it’s all formula’s based on the cube. So my question is when I select the front page in the data range (drop down) and then I need to select the which sheets need to be refresh here [ based on the checkbox selection] the data needs to be refresh.

I have attached the sample worksheet for your reference, suggest me the macro automatic refresh based on the check box and the sheets.

Thanks
Raju

[Winon]

Hello rajuganapathy,

Your profile shows that you are using Excel 2003, yet you attach a sample Workbook with a .xlsb extension.

Please update your profile to show exactly which version of Excel you are using, since it is important to know for Forum Members wanting to assist. You may receive a solution based on features available only in Excel 2016, while you may not be running on your system, rendering the solution worthless to you.

Regards.

[rajuganapathy]

Hi Winon,

Sorry it's a XLSM file. am unable to attach the xlsm version here. Thank you.

Regards
Rajaganapathy Pommaiyan

[Winon]

Please update your profile to show exactly which version of Excel you are using.

[rajuganapathy]

Hi Winon,

Dont know how to upload the version modified file, could you please help me or save the file xlsm. Please.

Regards
Raju

[rajuganapathy]

Hi All,

Help me to fix the issue. Thanks

[323100N]

I think Winon is referring on your Profile information;

Join Date
09-15-2011
Location
London
MS-Off Ver
Excel 2003 < ------This is what he/she is referring to update your Excel version you are using
Posts
81

[rajuganapathy]

It's done, could you glad to help me?...

[Winon]

Hello rajuganapathy,

Unfortunately I don't have access to Excel 2016, and I shall therefore not be able to assist, as my System cannot always read Excel 2016. So Sorry.

Regards.

[rajuganapathy]

Hi Winon,

It's doesn't matter about the Excel version, i requested a macro coding if you could share i will manage accordingly . kindly anyone help me. Thank you.


Kind regards
Raju

[rajuganapathy]

Gents,

Any update?...