Excel copy/paste function works intermittently and stops

When using copy/paste function in Excel, it works intermittently on some Worksheets and doesn't work on others. This occurs after using Excel and leaving it idle for some time.

The Enable Live Preview feature is greyed out on all office apps as well.