This is typically not a wanted behavior inside spreadsheets and in this article you will learn a couple ways to prevent this type of auto-correction from occurring within Excel. If this is important to you, the only option is to make sure that you add the hyperlinks before sharing the workbook and first turning on Track Changes. By default Excel will convert text to a hyperlink if it determines your data is in a URL or email address format. In the process of unsharing the workbook, Excel will turn off the tracking and discard the change history. There is one caveat in taking this approach to adding the hyperlink-you need to be careful that you don't unshare the workbook if you have the Track Changes feature of Excel turned on. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine. Want to remove those clickable links from your Microsoft Excel spreadsheets If so, it’s easy to remove those links or prevent Excel entirely from turning your typed text into web links. If you absolutely must add the hyperlink to the workbook, the only option is to unshare the workbook, add the hyperlink, and then again share the workbook. When you choose to share a workbook, some options in Excel are simply not available any more inserting hyperlinks is one of those options that is removed once the workbook is shared. Your email address will not be published. Dan wonders if there is a way to insert hyperlinks into shared workbooks. Now the user was able to open Excel document from Sharepoint 2010 in Excel instead of IE. However, as long as the workbook is shared, the hyperlink features in Excel are not available. Dan has a shared workbook into which he needs to insert a hyperlink.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |