Hello! In a tab I use a sort function with a nested filter function:
=SORTIEREN(
FILTER(tbl_Konten[Buchungsdatum]:tbl_Konten[MonatsSaldo];
(tbl_Konten[Gegenkonto]=$B$1)
*(tbl_Konten[Wertstellung]>=D1)
*(tbl_Konten[Wertstellung]<HEUTE());"")
)
in the way that I use a dropdown in B1 to select a wanted value. When I hit "calculate sheet" in Formulas, Exel crashes, however, if I choose calculate now or manually click in the on my formula above and hit enter, it works. So the problem doesnt seem to be in the formula. I tried to replace all cell references with static values but the issue persists.
What could be the problem?? I am using Mac OS 13.1 (22C65), Excel for Mac 16.69 (23010700)
thank you!!
