Forum Discussion

Copper Contributor

Aug 07, 2019

Copy/paste from one Excel sheet to a sheet in another file pastes only values, not formulae

Hi, I'm embarrassed to have such a simple problem but be unable to solve it myself, but it would really help if somebody can help me. I have Excel workbooks/worksheets to calculate stuff for invoici...

excel

Formulas and Functions

Twifoo

Silver Contributor

Aug 07, 2019

Perhaps, there are some add-ins that prevent the execution of paste special options. If that is so, you must disable them.

cyenglert

Copper Contributor

May 20, 2020

Twifoo

I have the same problem and I have no add-ins active.

This is really frustarting and not able to use Excel because it won't copy the formula, only the value. It would appear it is a setting in preferences but I can't find any that relate.