Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-794092%22%20slang%3D%22en-US%22%3ECopy%2Fpaste%20from%20one%20Excel%20sheet%20to%20a%20sheet%20in%20another%20file%20pastes%20only%20values%2C%20not%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794092%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20embarrassed%20to%20have%20such%20a%20simple%20problem%20but%20be%20unable%20to%20solve%20it%20myself%2C%20but%20it%20would%20really%20help%20if%20somebody%20can%20help%20me.%3C%2FP%3E%3CP%3EI%20have%20Excel%20workbooks%2Fworksheets%20to%20calculate%20stuff%20for%20invoicing%20and%20they%20are%20simple--no%20macros%2C%20no%20references%20to%20other%20worksheets%2C%20etc.%20%26nbsp%3BI%20wanted%20to%20copy%2Fpaste%20a%20newer%2C%20functioning%2C%20worksheet%20into%20another%20workbook%2C%20but%20it%20copies%20and%20pastes%20only%20values%2C%20not%20formulas.%20%26nbsp%3BWell%2C%20that's%20essentially%20useless.%20%26nbsp%3BI%20can't%20even%20copy%20a%20single%20cell%20and%20paste%20it%20with%20its%20formula%2C%20let%20alone%20a%20whole%20sheet.%20%26nbsp%3BI%20tried%20%22paste%20special%22%20and%20to%20select%20formulas%20off%20the%20pick%20list%20there%2C%20but%20the%20program%20won't%20allow%20me%20to%20pick%20any%20of%20those%20special%20paste%20options.%20%26nbsp%3BWhat%20do%20you%20think%20may%20be%20wrong%3F%20%26nbsp%3BThanks%20very%20much%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-794092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794205%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20from%20one%20Excel%20sheet%20to%20a%20sheet%20in%20another%20file%20pastes%20only%20values%2C%20not%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794205%22%20slang%3D%22en-US%22%3EPerhaps%2C%20there%20are%20some%20add-ins%20that%20prevent%20the%20execution%20of%20paste%20special%20options.%20If%20that%20is%20so%2C%20you%20must%20disable%20them.%3C%2FLINGO-BODY%3E
Rosalynn
Occasional Visitor

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 invoicing and they are simple--no macros, no references to other worksheets, etc.  I wanted to copy/paste a newer, functioning, worksheet into another workbook, but it copies and pastes only values, not formulas.  Well, that's essentially useless.  I can't even copy a single cell and paste it with its formula, let alone a whole sheet.  I tried "paste special" and to select formulas off the pick list there, but the program won't allow me to pick any of those special paste options.  What do you think may be wrong?  Thanks very much in advance

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