Windows 10: How to link to a specific cell in a specific worksheet in an XLSX file from another XLSX

I have a XLSX spreadsheet that I want to create a link in to another XLSX workbook so it opens at a specific cell in a specific worksheet.I have the format of HYPERLINK that will do this. However, that uses a http:// reference. If I substitute the local drive reference where the file actually resides, Excel opens the workbook after the "this is dangerous! - Yes/No" question but fails to open at the specific worksheet- says "Reference is invalid".The format I am using is -=HYPERLINK "[C:\Users\User\OneDrive\Documents\Utilities\Calcs.xlsx]Detailed costs by month!B5", "click to open more d

:)

 

Default file type to Microsoft Excel worksheet instead of XLSX file

Hello,

Due to some error in opening of excel file I had to change the default file type under .XLSX file,

It was changed to XLSX file instead of Microsoft excel worksheet, now I want change it back to original but I am unable to do the same, kindly check highlighted image below & suggest.

Thank you

 

xlsx files can't open

Hello Donald,

.XLSX is a file extension for an open XML spreadsheet used by Microsoft Excel. For us to better assist you, we'd like to know the following:

• Confirm which build is currently installed on your device. To check, follow the steps below:

• Press Windows key + R, then type in winver.
• Click OK.

• Is Microsoft Excel installed on your computer? If yes, which version of Microsoft Excel are you using?
• Are you getting any error messages when opening the .xlsx files?
• Did you create the said file or was it downloaded from a certain source?

We look forward to your response.

Regards.

 

xlsx files

I rebooted my computer and now all my files are xlsx and can not open please help