This process results in a message that the Formula is too long, which I can't
get out of... I have to end out. Anything else?

"Gary Brown" wrote:

On the top menu command bar...
select 'EDIT'
select 'Links...'
select the link to be changed
point to your 'different workbook'
select 'OK'
select 'Close'

Note that the worksheet name in both workbooks must be the same.
ie: if you were referencing Sheet17 in the original workbook, your new
workbook must have a Sheet17.

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Roger" wrote:

I have a workbook with a column full of simple formulas that I need to copy
and paste to an different workbook. When I do this it creates a link in the
formula to the original workbook from which I copied. Is there an easy way
to remove the links and retain the correct formulas? It would save hours...

Thanks in advance
Roger

Actually I take back most of the previous post, after clicking "ok" a bunch
of times it worked, although the links don't immediatly work until you save
the file. But it got me a lot closer, thanks a ton Gary!

"Roger" wrote:

This process results in a message that the Formula is too long, which I can't
get out of... I have to end out. Anything else?

"Gary Brown" wrote:

On the top menu command bar...
select 'EDIT'
select 'Links...'
select the link to be changed
point to your 'different workbook'
select 'OK'
select 'Close'

Note that the worksheet name in both workbooks must be the same.
ie: if you were referencing Sheet17 in the original workbook, your new
workbook must have a Sheet17.

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Roger" wrote:

I have a workbook with a column full of simple formulas that I need to copy
and paste to an different workbook. When I do this it creates a link in the
formula to the original workbook from which I copied. Is there an easy way
to remove the links and retain the correct formulas? It would save hours...

Thanks in advance
Roger