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. |
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 |
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 |
All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com