Hi

I want to disable "Update Remote Reference" in Tools->Options->Calculate tab of excel for a particular workbook. I used ActiveWorkbook.UpdateRemoteReferences = false in the code before saving the workbook.
But everytime I open this workbook again, it prompts me to update references.

How can this be done ?

thanks!

Not sure what version of Excel you are using I am using 2003, but you could try the following in the worksheet
 edit->Links then click on Startup Prompt, it gives you a few options about how you want external references treated.. Hope this helps

Hi rogers

That helpped .

Thanks !