Changing file links to manual

Cryp · Mar 4th, 2002, 07:01 PM

I require the automatic file link update (when you open the workbook) to be changed to manual update but the section in "Edit - Links" is not available. Is there any way to change the file linking to manual?

Thanks

Barrie Davidson · Mar 4th, 2002, 07:06 PM

Quote:

On 2002-03-04 18:01, Cryp wrote:
I require the automatic file link update (when you open the workbook) to be changed to manual update but the section in "Edit - Links" is not available. Is there any way to change the file linking to manual?

Thanks

When you open the spreadsheet you are prompted to update the links. If you select no, your links will then be manual (ie, can only be updated manually).

Does this help you out?

Regards,

Cryp · Mar 4th, 2002, 07:15 PM

Thanks for the reply but it doesn't really help me. I don't want the prompt to update the links to appear when I open the workbook. The linked file is exported from Access and is saved as Excel 5. The automatic update comes up with an error message when you click "Yes" to update. I have a small VBA routine that will save the linked file as Excel 7 and then update the files.

Barrie Davidson · Mar 4th, 2002, 07:20 PM

Quote:

On 2002-03-04 18:15, Cryp wrote:
Thanks for the reply but it doesn't really help me. I don't want the prompt to update the links to appear when I open the workbook. The linked file is exported from Access and is saved as Excel 5. The automatic update comes up with an error message when you click "Yes" to update. I have a small VBA routine that will save the linked file as Excel 7 and then update the files.

Are you opening the file using VBA? If so, you can disable the update links by using this syntax:

Workbooks.Open FileName:="Book1.xls", _
updatelinks:=0

Am I getting close?

Mar 4th, 2002, 07:32 PM

Getting close but I am opening the workbook manually. Is there any code I can put in the "Workbook Open" that will disable the update?

Cryp · Mar 4th, 2002, 07:34 PM

Quote:

On 2002-03-04 18:32, Anonymous wrote:
Getting close but I am opening the workbook manually. Is there any code I can put in the "Workbook Open" that will disable the update?

Sorry - forgot to put my Username in

Barrie Davidson · Mar 4th, 2002, 07:39 PM

Sorry, but if you're opening it manually you're going to be stuck with the prompt when you open it.

Cryp · Mar 4th, 2002, 07:53 PM

The Microsoft Knowledge base said you have to use the "ExcecuteExcel4Macro method to run the SET.UPDATE.STATUS() macro command." They also give an example but they use MS Word - dumb and confusing - most people who link files in Excel are linking to other Excel files. Thanks for trying.

Mar 4th, 2002, 07:39 PM	#7
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Sorry, but if you're opening it manually you're going to be stuck with the prompt when you open it. __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 07:01 PM	#1
Cryp New Member Join Date: Mar 2002 Posts: 4	I require the automatic file link update (when you open the workbook) to be changed to manual update but the section in "Edit - Links" is not available. Is there any way to change the file linking to manual? Thanks

Mar 4th, 2002, 07:15 PM	#3
Cryp New Member Join Date: Mar 2002 Posts: 4	Thanks for the reply but it doesn't really help me. I don't want the prompt to update the links to appear when I open the workbook. The linked file is exported from Access and is saved as Excel 5. The automatic update comes up with an error message when you click "Yes" to update. I have a small VBA routine that will save the linked file as Excel 7 and then update the files.

Mar 4th, 2002, 07:32 PM	#5
Guest Posts: n/a	Getting close but I am opening the workbook manually. Is there any code I can put in the "Workbook Open" that will disable the update?

Mar 4th, 2002, 07:53 PM	#8
Cryp New Member Join Date: Mar 2002 Posts: 4	The Microsoft Knowledge base said you have to use the "ExcecuteExcel4Macro method to run the SET.UPDATE.STATUS() macro command." They also give an example but they use MS Word - dumb and confusing - most people who link files in Excel are linking to other Excel files. Thanks for trying.