Forum Discussion

bob_sipes's avatar
bob_sipes
Copper Contributor
Jun 25, 2020

Copying formulas between spreadsheets without referencing the original spreadsheet

how do i copy a formula from 1 spreadsheet to another, and keep the formulas from referencing the original spreadsheet? I want the formulas to work in my new spreadsheet, instead of referencing the s...
  • bob_sipes 
    If I understood well your question, to resolve that, I usualy go to Data / Queries & Connections / Edit Links => Select the original spreadsheet ([MORSUM 2017.xls], on your exemple) => hit "Change Source" bottom => select the new spreadsheet.

    Usualy It works.

     

    But you must be carefully, in one case: If you have another cells in the same spreadsheet, with formulas (that you don't want to change) with references to the original spreadsheet, you will have a problem, because the formulas also going to be changed.