This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
I have used the solution presented across many files (using the xl/workbook.xml) to find named ranges in Excel files. I just ran into an .XLSM (I've successfully used this approach on XLSMs prior to this) where instead of getting a return of the named ranges, I get a list of sheet names instead (from xl/wookbook.xml). I'd really appreciate some help here. Any idea why I'm getting back sheet names (useless to me) instead of named ranges? I cannot attach the source file as it's confidential.