Copying worksheet to different workbook

A

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)
 
M

macropod

Hi Anode,

If you look in the destination worksheet, you'll see that the references in the forumlae now have the original file's name enclosed
in square brackets, like [Book1]. Simply copy the original file's name and the square brackets, then do a Find/Replace, by pasting
the copied data into the 'Find' box and leaving the 'Replace' box empty.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pasting a worksheet 4
Copying worksheet messes up form elements 0
copy form exel spredsheat 1
Multiple hyperlinks in one cell 4
Referencing Cells in another workbook 1
Is there a way to have a file automaticallyopen a VBA macro on a PC but an AppleScript on aMac? 3
Do you shut down your Macbook Pro when you are not using it? 2
having two different versions of office on same computer 3

Top