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) )
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) )
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 restarted my computer and now it's working again... I feel silly. X_X Thank you all for the help!
