How to fix Excel not allowing to copy data from one worksheet and paste into another worksheet within the same workbook?

By supporting this issue, most people were helped by this Solution.

Boost your productivity at unbelievably low costs with our 100% legal Microsoft licenses! Explore super affordable deals, unlock powerful features, and transform your digital experience today. Upgrade now for legitimate value!

  • Open the worksheet (ex. Sheet1.xlsx)
  • Select the File -tab
  • Click Advanced
  • Enable (or disable) The Lotus compatibility Settings for: Sheet1.xlsx by enabling (or disabling) the options:
  • Transition formula evaluation and Transition formula entry
  • Click OK
Scroll to Top