How to change default settings of "Save external links values" and "Update links to other..

[mkollman]

Every time I move one sheet to a new book, the check boxes of "Save external links values" and "Update links to other documents" in the new book are checked. How can I make the default of a new book for these values to be unchecked. The size of the files differs very much, 72 kb when not checked and 1.2 mb when checked.

 

[Diablo II]

well you can make a templet with the checkbox not checked and open it to make a new worrbook. or you can do a befoursave code and set the checkboxes to = false.

 

[mkollman]

I have made a default book.xlt file with these settings but when i open it it turns them on again. Remember I right click the sheet in the old xls and move the sheet to a new workbook.
How can I write a code to uncheck these check boxes?

 

[xenou]

just record the code with the macro recorder:

Sub Macro1()
    With ActiveWorkbook
        .SaveLinkValues = False
    End With
End Sub

What does save link values do when you set it to false? I'm not sure where your "update links to other documents" is...

Why do you want a linked file without links being updated...seems pretty useless - don't you have to update these links at some point?

Alex