I have an Excel with this formula (simplified):
=MATCH($M20,'OtherSheet'!Print_Titles,0)
I am trying to match a string in M20 cell with Print_Titles named range.
This keeps returning #NAME when I save the file via Asp…... Hopefully we will figure out your issue soon....