All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B
sheet 1 it will not let me with out pulling up the office clip board and it
never used to do this. I used to be able to just highlight, right click, and
hit copy then go to the other workbook, right click, and hit paste. Also it
will not copy the formulas over just the values. Any suggestions why?