Hi,
I created an Excel file with functions/formulas which I keep as a template which is cleared from raw data input. I want to implement the functions in other Excel files and make them work automatically right away. When inserting data input directly in the Excel template, all functions are calculating and updating automatically, this is not the case when I copy the functions and paste it in another Excel file. I get errors such as "#REF" and need to solve it manually. I have tried several paste options but I can still not manage to make it work automatically. At the moment, I need to put the cursor in the function's field and then hit ESC. Then the "#REF" turns to "0". Afterward I need to click "Calculate sheet", in order for the formula to calculate the correct values.
Can anyone please support me in how to solve this problem?
I created an Excel file with functions/formulas which I keep as a template which is cleared from raw data input. I want to implement the functions in other Excel files and make them work automatically right away. When inserting data input directly in the Excel template, all functions are calculating and updating automatically, this is not the case when I copy the functions and paste it in another Excel file. I get errors such as "#REF" and need to solve it manually. I have tried several paste options but I can still not manage to make it work automatically. At the moment, I need to put the cursor in the function's field and then hit ESC. Then the "#REF" turns to "0". Afterward I need to click "Calculate sheet", in order for the formula to calculate the correct values.
Can anyone please support me in how to solve this problem?