Break link trong excel 2010

PowerPoint for trinhde.vn 365 PowerPoint 2021 PowerPoint 2019 PowerPoint năm 2016 PowerPoint 2013 PowerPoint 2010 PowerPoint 2007 More...Less

If a slide in your presentation contains a link khổng lồ an external file (such as a video clip file, or a chart that is linked to lớn an Excel worksheet) and the external tệp tin gets moved or deleted, you’ll get an error message (similar khổng lồ the one shown below) when you try khổng lồ edit the data. To fix this, you can either update the broken liên kết, or remove sầu it.

You watching: Break link trong excel 2010

*


On the File tab, cliông chồng Info, và in the lower right corner, under Related Documents, clichồng Edit Links to lớn Files.

*


Do one of the following:

If you know the new location of the linked external tệp tin, click Change Source, go to lớn the new location of the external file, & then clichồng Open. In the Links các mục, cliông chồng the correct path to lớn the linked worksheet, and then cliông xã Update now.

If you don’t know what happened to the external tệp tin, cliông xã Break Link. The content will still appear in the slide, but it will be embedded in the presentation instead of linked. In the case of an Excel chart, for instance, the chart data that appears on the slide becomes static when you break the liên kết. If you were to lớn update the original worksheet on which the chart is based, the chart won"t be updated as the original worksheet any more.

See more: Top 8 Máy Tính Bảng Dưới 5 Triệu Nên Mua Máy Tính Bảng Nào, Máy Tính Bảng Dưới 5 Triệu Đáng Mua Nhất

*

See Also


On the Office button, select Prepare, and then select Edit Links khổng lồ Files at the kết thúc of the các mục of options.

*

If you don"t see Edit Links to lớn Files, make sure you"ve saved your presentation.

Do one of the following:

If you know the new location of the linked workbook, clichồng Change Source, go to the new location of the Excel workbook, & then cliông xã Open. In the Links các mục, cliông chồng the correct path to lớn the linked worksheet, and then click Update now.

See more: Xem Phim Lee Min Ho Mới Nhất 2021, Lee Min Ho Và 6 Bộ Phim Nổi Bật Trong Sự Nghiệp

If you don’t know what happened khổng lồ the Excel worksheet, clichồng Break Link. The chart will still appear in the slide, but the data will not be updated as the original worksheet continues khổng lồ change.

*


*
*
*

Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)