+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    08-29-2007
    Posts
    18

    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!

  2. #2
    Registered User
    Join Date
    08-29-2007
    Posts
    18

    Done it...

    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.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325
    Just a wild guess, but if you paste your formulas in the next book then - Edit - Links - Change source

    With this be an option?

  4. #4
    Registered User
    Join Date
    08-29-2007
    Posts
    18
    Hi arthurbr,

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

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325
    Glad to help - Thx for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1