Can you just clear the cells on that City sheet.

Then select the cells on the new City sheet, edit|copy
off to the old City sheet
select A1 and edit|paste



create_share wrote:

I have a master (named Country) sheet which is taking data from another sheet
(named City) in the workbook through the links. Every week i am getting an
updated city sheet from my data entry operator. I want to replace the old
city sheet with the new city sheet with the same name. But when i delete the
old sheet and copy the new sheet with the same name, the master (Country)
sheet is showing #REF! in its cells.

Is ther any way i can accomplish this so that i can save my time from copy
and paste?

thankx!

--

Dave Peterson