Forum Discussion
Solved
Formula Changed And Now I'm Getting "#NAME?" Errors?
Good morning all! I've used a formula to calculate many aspects of my data - and it works amazing, until this week for some reason. Now whenever I change the filters on my table, the formula breaks: ...
- as noted SEQUENCE should definitely be recognized and you should fix your Excel.
also as noted that formula could probably be improved.
as for a quick fix to get rid of SEQUENCE I might try just deleting it and see if it works but if it is needed to make sure the array lengths for the MMULT() are correct then:
SEQUENCE( COLUMNS( Table57[[PM]:[CM5]] ), , 1,0) )
could be
TRANSPOSE(--LEN(Table57[[#HEADERS],[PM]:[CM5]] )>0) )
I checked and XLOOKUP and filter are available, but not sequence. Is there an easy replacement for that function?
That's odd. Which version of Excel are you running?
- Current version I am using is 2202 (Build 14931.20764)
The build refers back to the October update:
https://learn.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel#version-2202-october-11
SEQUENCE should be available in that version. You may want to try the following in this order (check your function list after trying each item below)
1. log out of 365 account through File | Account and then sign back in
2. Quick repair of M365 through control panel | programs and features - may take 5 to 10 minutes
3. Online repair of M365 - may take 60 minutes. It's essentially a re-installation- as noted SEQUENCE should definitely be recognized and you should fix your Excel.
also as noted that formula could probably be improved.
as for a quick fix to get rid of SEQUENCE I might try just deleting it and see if it works but if it is needed to make sure the array lengths for the MMULT() are correct then:
SEQUENCE( COLUMNS( Table57[[PM]:[CM5]] ), , 1,0) )
could be
TRANSPOSE(--LEN(Table57[[#HEADERS],[PM]:[CM5]] )>0) )