Dec 17, 2009  Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a few files that when opened in Excel 2007 Windows show that no files are linked, when I open the file in Excel 2008 Mac and look in the EDIT LINKS two external file links show up. With Kutools for Excel’s Find and Break broken Links, you can find all the external links of the active worksheet, at the same time, you can break the specific links as you need. Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 60 days.

Note: To fix multiple links, hold down, and then click each link. • Click Change Source. • Browse to the location of the file containing the linked data. • Select the new source file, and then click Change Source. • Click Close. Remove a broken link When you break a link, all formulas that refer to the source file are converted to their current value.

For example, if the formula =SUM ([Budget.xls]Annual!C10:C25) results in 45, the formula would be converted to 45 after the link is broken. • Open the workbook that contains the broken link. • On the Data tab, click Edit Links. The Edit Links command is unavailable if your workbook doesn't contain links. • In the Source file box, select the broken link that you want to delete. Note: To fix multiple links, hold down, and then click each link. • Click Change Source.

• Do one of the following: To Do this Fix a broken link to a sheet in another workbook In the Open dialog box, locate the workbook, and then click Change. Fix a broken link to a workbook or other Office document Type the new name or location for the document in the Change links to text box, and then click OK. Turn off automatic updates for linked data • Open the workbook that contains the broken link. • On the Edit menu, click Links. The Links command is unavailable if your workbook does not contain links. • In the Source file box, click the broken link that you want to fix. Note: To fix multiple links, hold down, and then click each link.

• Click Manual. Remove a broken link When you break a link, all formulas that reference the source file are converted to their current value. For example, if the formula =SUM ([Budget.xls]Annual!C10:C25) results in 45, the formula would be converted to 45 after the link is broken. • Open the workbook that contains the broken link. • On the Edit menu, click Links. The Links command is unavailable if your workbook does not contain links.

Best security programs for mac. • In the Source file box, click the broken link that you want to remove.

A few weeks ago, all of the hyperlinks in one of my Excel files mysteriously broke. For example, I have over 5,000 links which point to files on a network share.

These hyper links now point to c: users user.name application data file123.pdf. Here is some context and troubleshooting I have done: • I have verified that the original UNC path is still in tact • If I delete and recreate any of the Hyperlinks they work properly • This file is accessed by 3-4 users, all which are using Microsoft Office 2010 SP1 32 bit • The server that hosts the file share is running Windows Server 2008 R2 64 bit Please help.