| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbook.TemplateRemoveExtData property (Excel) |
vbaxl10.chm199171 |
|
|
9851df1d-4e83-525a-8a43-bd84b0a94c74 |
05/29/2019 |
medium |
True if external data references are removed when the workbook is saved as a template. Read/write Boolean.
expression.TemplateRemoveExtData
expression A variable that represents a Workbook object.
This example saves the workbook as a template that contains no external data.
With ThisWorkbook
.TemplateRemoveExtData = True
.SaveAs "current", xlTemplate
.TemplateRemoveExtData = False
End With[!includeSupport and feedback]