pasting a worksheet

[anode505]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I need to add a worksheet that has links to cells on another worksheet in the same workbook, over to another workbook. The copy/move works, but, the links to the cells point to the original workbook. Is there an easy way to copy it over?

(I need to do this with a few hundred files. updating older versions and manually editing a few hundred files isn't in the cards)

posted this earlier, but its been closed. One suggestion was to do a simple search/replace, but it doesn't turn up any matches to replace.

I'm 1/2 tempted to write a macro (or applescript) to make the worksheet, and paste each cell, but thats going to be a bear too.

 

[anode505]

Well working on a Applescript solution.
How do I create a new worksheet via AS? and name it?

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I need to add a worksheet that has links to cells on another worksheet in the
same workbook, over to another workbook. The copy/move works, but, the links
to the cells point to the original workbook. Is there an easy way to copy it
over?

(I need to do this with a few hundred files. updating older versions and
manually editing a few hundred files isn't in the cards)

posted this earlier, but its been closed. One suggestion was to do a simple
search/replace, but it doesn't turn up any matches to replace.

I'm 1/2 tempted to write a macro (or applescript) to make the worksheet, and
paste each cell, but thats going to be a bear too.

After you move or copy the worksheet, Try Edit-Links, change Link, to point
the links to the new workbook.

 

[anode505]

thanks Bob. But I resolved it via AS. I just wrote a program to create name and paste in what I wanted.

But with your link theme, would I have to go to each one individually or could it be global like a find/replace all?

 

[Bob Greenblatt]

thanks Bob. But I resolved it via AS. I just wrote a program to create name
and paste in what I wanted.

But with your link theme, would I have to go to each one individually or could
it be global like a find/replace all?

Replacing the links on a workbook updates all the links in the workbook that
linked to the same source.