This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm using Microsoft office 365 & in Excel when I use =HYPERLINK("[PUR-MON-YEAR.xlsm]LIST-OCT!a1") the destination file(PUR-MON-YEAR) opens & I get "reference isn't valid" error and goes to the First worksheet of the file instead of the "list-oct" worksheet ( because of the "-" in the worksheet name "list-oct" there is no problem of "-" in the File name, only issue with worksheet name, if i change that "-" to "_" or any other character it works fine.
so the question is cant we use the "-" hyphen in the worksheet name with respect to the =Hyperlink(), what is the solution and workaround
replacing the "-" in worksheet names is not an option for me due to standard naming format to follow
Regards
Ravi
Moved from : Office / Excel / Microsoft Office Programming / Office 365 Home
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Try putting single quotes (apostrophes) around the sheet name.
=HYPERLINK("[PUR-MON-YEAR.xlsm]'LIST-OCT'!A1")