Updating Links

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am trying to change links within a workbook. I go to
view----links-----change source. I click on the file and
click ok. I receive the following message "Formula too
long." I can click ok many, many times and it will finally
go away but the source does not change. Has anyone ever
experienced this? I am trying to update the links through
VBA as we speak. I will let you know the outcome. Thanks
for your help.

Mike
 
I was able to use the Activeworkbook.changelink method to
update the links but I am still curious as to why I was
unable to do it through the menu.
 
excel is limited to 1024 characters in a formula (measured when you're in R1C1
reference style mode).

Maybe you can shorten your formulas by shortening the path, workbook name,
worksheet name????
 
Back
Top