Question: Q: Mac shortcuts not working in Mac Excel - MS Office. I have the new 2013 MacBook Pro. I have purchased Microsoft Office for Mac, which is what I'm using when I say 'Mac Excel' I am a power excel user in PC Excel but am having a hard time in Mac's excel, as many of the Mac excel shortcuts don't work. Hyperlink not working in Excel. I am new to file sharing on Dropbox and am looking to use Dropbox to house an excel spreadsheet which has hyperlinks to pdf's. I emailed the spreadsheet as an attachment to my colleague direct from excel and when they opened the spreadsheet and clicked on the hyperlink for the PDF they got an. Note that some browsers and email accounts will not recognize a Subject line. HYPERLINK TO A CHART SHEET Unfortunately there is no standard way to link to a Chart Sheets. In fact, Excel will not let you do this. The workaround to this is quite simple though. 1) Add a new Worksheet.
You would need to correct the hyperlink address to the updated file name so that the file becomes detectable. Follow the steps below to edit the address. Step 1: Copy the address of the new file from the file's explorer. Step 2: Head to Excel. Step 3: Right-click on the hyperlink, and click 'Edit hyperlink' in the menu. I had the same issue using Sharepoint 2013. It didn't matter how I created the link in Excel, it would look like a link but was unclickable (using ctrl+click or any other combination). The only way I was able to add a working link was to open the spreadsheet in the Sharepoint Excel Web Access editor.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
If you have Skype installed, see Text has incorrect format when using paste in Microsoft Office for more information. The Paste Special option can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep (source or destination) or by stripping all the formatting and just pasting the text. If you are having issues with the Paste Special option, continue on to the resolutions below.
Excel Links Stopped Working
Resolution
To see if the Paste Special option is enabled:
- Go to File > Options > Advanced.
- Under Cut, copy and paste, ensure the Show Paste Options button when content is pasted option is checked.
Note
Using the Worksheet_SelectionChange event will clear the clipboard, which disables the Paste Special option. To enable the option, you need to set the value of the Application.EnableEvents property to False.
Ensure that all instances of the web browsers that you use are closed and try to use the Paste Special option again. Paste special will not function if your web browser is causing the conflict. Windows Internet Explorer (8-9) do not conflict with the Paste Special option in Excel 2010. Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option. To determine if an add-in is causing the issue:
Links Not Working In Excel
Find the Microsoft Excel icon.
Press and hold the CTRL key and double-click the application shortcut.
Click Yes when a window appears asking if you want to start the application in Safe Mode.
Note
If you have an icon on your desktop, hold the CTRL key and click on the icon. This works with any Microsoft Office product.
If the Paste Special option works in the Safe Mode as follows, enable your Add-ins one by one until you hit that one that is causing the conflict. Leave that one disabled or uninstall it.
Note
For more information, see Adding or Removing Add-ins and Working with Office Safe Modes..
|
Why Are My Excel Hyperlinks Not Working
You can also get help from the Microsoft Community online community, search for more information on Microsoft Support or Windows Help and How To, or learn more about Assisted Support options.