Forum Discussion
Named items are now evaluating to #VALUE! errors in Function Arguments menu
I noticed an interesting quirk between the various 365 channels this afternoon. I understand AFE doesn't always sync with name manager so I tried re-loading AFE to confirm the presence of the named item. I've also wiped all named items and tried it again. Same issue in Safe Mode, too.
The formula still calculates despite the error in function arguments.
Has anyone noticed this quirk?
Current Channel (Version 2212, also happening on Beta Channel v 2303)
Current Channel (2201 - not fully updated. No errors. This also works on the Semi-Annual Channel).
2 Replies
I think it is only with LET local variables that I have seen these missing parameters. I wasn't clear, did 'colors' show in the ordinary Name Manager?
- Yes. After more testing it seems this quirk is affecting functions which only accept ranges like COUNTIF, SUMIF, AVERAGEIF, etc. Array-friendly functions are not affected.
