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

mkollman

New Member
Joined
Dec 7, 2008
Messages
2
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.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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.
 
Upvote 0
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?
 
Upvote 0
just record the code with the macro recorder:

Code:
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
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top