View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default "formula too long"

Hi Bobbie,

EDIT | LINKS | select the old link on the list, click on change and choose
the new one

hth
regards from Brazil
Marcelo

"BobbieB" escreveu:

Any help would be apprecated....I have several links in a file. The files
were moved from one server to another. I can't access the old server. I
need to update the links to reference the files on the new server. The
source and destination files are both open. I clicked edit, links, change
source and selected the new file. I get an error that indicates the formula
is too long.

I think this is because the old path is in the formula.
=SUM('C:\Customer Services\Mickey\xxxx Portfolios\Marketing
Initiatives\Sellout segmentation\Plan Sellout\4+8 fcst\[Revenue Sellout -
Monthly GL Amounts - xxx Trns.xls]2006'!E7:E10)

How can I make the updates without editing the individual formulas.

Thanks