| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping formulas
Everytime I copy formulas I get " inconsistent formula" or "unprotected
formula". They are inconsistent and unprotected, that's not the problem. Is there any set up to ignore this without doing it manually everytime I do the pasting ? After hundreds of pasting and clicking " ignore error" I'm ready to quit. Thanks for your answer. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coping formulas
in xl2003 menus:
Tools|Options|error checking tab uncheck the warnings you don't want computexcel wrote: Everytime I copy formulas I get " inconsistent formula" or "unprotected formula". They are inconsistent and unprotected, that's not the problem. Is there any set up to ignore this without doing it manually everytime I do the pasting ? After hundreds of pasting and clicking " ignore error" I'm ready to quit. Thanks for your answer. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coping formulas
YES! That is it. Thanks Dave.
"Dave Peterson" wrote: in xl2003 menus: Tools|Options|error checking tab uncheck the warnings you don't want computexcel wrote: Everytime I copy formulas I get " inconsistent formula" or "unprotected formula". They are inconsistent and unprotected, that's not the problem. Is there any set up to ignore this without doing it manually everytime I do the pasting ? After hundreds of pasting and clicking " ignore error" I'm ready to quit. Thanks for your answer. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Coping formulas | Excel Worksheet Functions | |||
| Looking to copy a worksheet with all formats and formulas without coping inputed data | Excel Discussion (Misc queries) | |||
| coping formulas from one cell to another | Setting up and Configuration of Excel | |||
| Coping text using Formulas - | Excel Discussion (Misc queries) | |||
| coping a formulas to another cell. | Excel Worksheet Functions | |||
Linear Mode
