Windows 10: How do you create a link to a specific cell in an excel file on a shared drive that can be...

Looking to create a link to a specific cell of a worksheet that is saved on a shared drive. I found how to link from one cell to another and from word to a cell in an excel file but have not been able to find a format to send to someone in an email or message them with. Just being able to type it in file explorer would be fine. Please help! or let me know if you need more information to be able to. Thanks!!

:)

 

Definitive statement of Excel single cell capacity limitations

Realize Excel is not designed to be a word document. Typically, a cell would hold a title or some short text far less then 255 characters. With that if you need far more than the cell limitation, you could either insert a Word document... Insert an object in your Excel spreadsheet. There's also the option to link to documents such as Word, PDF or website from within Excel *Wink

At the end of the day, you're not going to overcome the cell limit, so I suggest you look for alternatives as suggested above.

Good luck

 

Cannot access shared network drive

I could scream! so much time wasted on this stupid error, as if time is not precious enough!
It probably would work fine if I could see the other computer! But I cannot see the other computer!

 

Excel shortcut to open to specific sheet

Have you googled "Open excel workbook on specific sheet"? Couple of examples.

Seems you have to have macros enabled which is a security risk.

One such example which even allows you to target cell.

Easy steps to open an Excel workbook to a specific worksheet

I have not tried.

Ken