Refresh worksheet calculations when archiving a workspace

I have a worksheet on a workspace line that references another worksheet on child workspaces. When I archive a workspace, the worksheet on the workspace line then changes the value to “hidden”. This has an upstream impact on parent worksheets that reference the child worksheets at 4 layers. Refreshing the worksheets on the parent line seems to fix the problem. Would it be possible to automatically refresh worksheets that reference workspaces when someone archives a product?