Thread: Coping formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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