4 Replies Latest reply on Oct 31, 2013 8:28 AM by Matt Lutton

    Errors CopyPasting Calculated Fields

    daniel hegenbarth


      I have a workbook with eight different data sources, each of which will populate its own worksheet. All eight worksheets will need to have the same 100 calculated fields. I tried selecting and copy+pasting calculated fields from the first worksheet into the others, but any field that references another calculated field is corrupted, and the reference to the calculated field within the formula is replaced by something like "[Calculation_3910930160623525]".This is persistent even if I copy+paste the underlying calculated fields first. Obviously I'd rather not manually recreate those calculated fields over all 8 worksheets.


      If there isn't a solution to this issue, is there a way to batch import calculated fields from a text file, or some other workaround?

      Thank you