外部ブックのソース ブックへのリンクを解除すると、 参照、ソース内の値を使用するすべての数式 ブックは現在の値に変換されます。 これは、 アクションを元に戻すことはできません。 コピー先ブックをバックアップとして使用します。

Learn about the recovery options in Windows. Find out how to reset your PC, go back to a previous version of Windows, or use media to reinstall Windows.

Learn how to get Microsoft Store updates for your apps and games. Download the latest versions of Microsoft Store apps and games.

Learn how to use antivirus protection in Windows Security to protect your Windows PC against malware, viruses, and other threats.

Find out how to submit a request for a refund for a purchase of digital Xbox content.

Improve your writing skills with Word's tools for spelling, grammar, and clarity. Find out how to check and correct errors in your documents.

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Learn how to back up apps, settings, files, photos, and Microsoft Edge favorites and preferences on your Windows PC.