Bug: Sheets array formula not updating

Hey there,

We encountered an issue when working with large array formulas in our excelsheet. The array formula is supposed to take data updates from the next sheet, but since the last spreadsheets update, the array formula does not update the values anymore. Only when copy/pasting the formulas again, it shows an updated version.

This issue is reported by various other users in our organisation, across different OS and devices. The issue has been reported at the same time as the dropdown issues since last OO update.

Video is included for explanations.

Hope this can be solved soon, the sheets are essential in our daily work :slight_smile:

Sorry I made a screen video, but the forum does not allow me to upload as a new user.

Hello @angie1,
Currently your trust level allows you to upload files, please provide us the screen recording showing the steps to reproduce the issue

Hello @angie1

Please try using workbook recalculation from Formula tab > Calculation > Calculate workbook. Will it calculate the date after a change?