Copying formula to new worksheet: how to stop formula linking to original source?

Dear Excel-ers,

I have a workbook (one of many) with many different sheets and have created a summary sheet that shows the important information derived from each worksheet (reaction time data), calculates the mean, sd, etc for each column, and highlights outliers.

I also have many workbooks with an identical structure but different data, that I would like to summarise in the same way. I thought I would be able to paste the formulas from one worksheet to another, but when I do this, the formulas remain specific to the original worksheet, so the data from the original worksheet is shown, rather than being updated according to the current data.

I'm sure there must be a simple way to do this that I'm missing. Does anyone have any suggestions? Let me know if you need further information.

Many thanks!

I've now done this by using search and replace but if anyone has a more elegant solution I'd be glad to hear it.

Cheers.

Just a wild guess, but if you paste your formulas in the next book then - Edit - Links - Change source

With this be an option?

Hi arthurbr,

Yes, that works a treat - thank you very much!

Glad to help - Thx for the feedback