copy linked sheets (excel)

Topic

New Reply

Once I had my excel file corrupted and could not be saved, either as different name or same name. I tried to copy sheet per sheet in to new workbook, which were linked to each other.
But the formulae still refer to original file, that made me re-wrote in new workbook/worksheet.

Perhaps there are way in case happen again?

many thanks

-Indra-

Reply | Quote

Replies

You can use Edit | Replace to change the references from the old workbook to the new one.
Start by making a backup copy of your workbook.
Open the new workbook
Let’s say that you have references looking like this:

'C:Folder[Workbook.xls]Sheet1'!A3

where C:FolderWorkbook.xls is the path and filename of the old workbook.
Select Edit | Replace.
Click Options >>
Specify that you want to search the entire workbook.
Specify that you want to search in formulas (this is the default)
In the ‘Find what’ box, enter (or paste) the path and filename exactly as displayed in the formulas, i.e.

C:Folder[Workbook.xls]

Note that the apostrophes ‘ and the worksheet name have not been included.
Leave the ‘Replace box’ empty.
Click ‘Replace All’.

Reply | Quote

I will try soon, usually it always works..
congrats for 50,000 post ya..
forever thanks

-indra-

Reply | Quote

Thanks, Indra,

Reply | Quote