How to I import a worksheet and have the data flow to formulas?

[lc130]

Hi,

I have a large workbook with one tab named "Data". Data in this sheet flows to formulas in other sheets. I have a separate worksheet also named Data that I want to import to the large workbook and have the data flow to the formulas. When I import the data sheet it appears as Data(2). I then tried deleting the original data sheet and renaming the imported sheet to "Data". Now I see that the formulas that reference the data sheet have changed from =Data! to =#ref!.

Any ideas?

Thanks

Charlie

[bebo021999]

Try this:
Choose all cells those error
1- Press Ctrl-G / Special / Formula / check to Errors box only / OK

Change all formulas in selection to text
2- Press Ctrl-H;
----Find what: =
----Replace with: just leave it blank, type nothing
press Replace All

Replace #REF with DATA
3- Ctrl-H again
----Find what: #REF
----Replace with:=DATA
Replace All

[arlu1201]

Do not copy the separate sheet over. Instead copy & paste special values into the existing sheet and the formulae with update.