Aug 07 2019 02:31 PM
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
Aug 07 2019 04:08 PM
May 20 2020 07:51 AM
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.