upadting question
 

Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the changes,
saving, closing,and reopening everytime u change the criteria for the
formula's. Hoping to be able to save then it will update then.

upadting question
 

Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
HTH
Daniel
Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the changes,
saving, closing,and reopening everytime u change the criteria for the
formula's. Hoping to be able to save then it will update then.

upadting question
 

Ok I think I entered it in right but it gives me a compile error: Invalid
outside procedure.

"Daniel.C" wrote:

Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
HTH
Daniel
Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the changes,
saving, closing,and reopening everytime u change the criteria for the
formula's. Hoping to be able to save then it will update then.

upadting question
 

I tested it with XL2003, XL2007. Which version do you own ?
Can you try :
ActiveWorkbook.UpdateLink ActiveWorkbook.LinkSources
or :
For Each lk In ActiveWorkbook.LinkSources
ActiveWorkbook.UpdateLink lk
Next lk
Daniel

Ok I think I entered it in right but it gives me a compile error: Invalid
outside procedure.

"Daniel.C" wrote:

Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
HTH
Daniel
Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the
changes, saving, closing,and reopening everytime u change the criteria for
the formula's. Hoping to be able to save then it will update then.