disable automatic update of references

  • Thread starter Daniel Schaedler
  • Start date
D

Daniel Schaedler

Hi

All my references in sheet B are wrong with one line difference.
I would like to insert a line in a sheet A without updating the references
in sheet B (pointing to A) beeing updated. (both sheets in the same
workbook)
I know that copy and paste values works, but I want also to keep all my
formating.
Is there a possibility to disable the automatic update of references?

tanks for your help

Daniel
 
Top