RFE 66825-Action Button option to Rebuild ALL Sheets/CurrentBook
Posted: Fri Feb 20, 2015 10:36 am
I have logged an RFE for this - please vote!
Calculation options for Action Button should include an option to Rebuild Workbook. Currently only the active sheet can be rebuilt.
A customer has a report pack with parameters collected on a control sheet e.g. Month, Company, Scenario.
The parameters are used across multiple sheets with Active Forms.
The client has to navigate to each sheet and update using an Action Button.
This is laborious and leads to possible errors or omissions should a sheet be skipped or not calculated.
A possible workaround would be macro code but this is not support in Web sheets currently.
Calculation options for Action Button should include an option to Rebuild Workbook. Currently only the active sheet can be rebuilt.
A customer has a report pack with parameters collected on a control sheet e.g. Month, Company, Scenario.
The parameters are used across multiple sheets with Active Forms.
The client has to navigate to each sheet and update using an Action Button.
This is laborious and leads to possible errors or omissions should a sheet be skipped or not calculated.
A possible workaround would be macro code but this is not support in Web sheets currently.