Forum Discussion
ecovonrein
Mar 30, 2023Iron Contributor
MAP x MAP
Can anyone tell me what is wrong with this formula? =MAP(C23:D23;C24:D24;LAMBDA(a;b;SUM(MAP(C5:G5;C6:G6;C7:G7;LAMBDA(c;d;e;1))))) I get #VALUE #VALUE. Thanks. PS: Works when you replace the SUM()...
- Oct 02, 2022UPDATE tblFXParent SET DateSettleC = DLOOKUP("LastOfDateSettle", "qryFXSettDtCLast", "IDParentfk = " & [IDFXParent])
Patrick2788
Dec 12, 2023Silver Contributor
Check the M365 account status in File | Account. There may be an error with a 'fix' button. If there's no error or fix doesn't work, try signing out of the account and log back in.
Stan_Bizot_690
Dec 13, 2023Copper Contributor
Thanks Patrick2788 . I tried what someone else suggested (Unticking the boxes for all add-ins at File / Options / Add-ins / Manage COM Add-ins / Go) and that fixed the problem. Thanks for the quick response.
Stan