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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies