A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi Gothro,
Thank you for sharing such a detailed report and for thoroughly testing the issue across different scenarios.
Based on your findings, the behavior appears consistent with the known issue involving workbooks that contain Conditional Formatting. However, your testing suggests that its impact may extend beyond paste operations, as it also affects Format Painter and the ability to create a copy of a worksheet.
To help ensure these additional findings reach the appropriate team, I recommend submitting this behavior through Help > Feedback > Report a problem in Excel. If possible, include the affected Office LTSC 2024 build numbers, the exact reproduction steps, a minimal sample workbook, and a screen recording demonstrating the behavior.
In the meantime, please continue using the workaround you identified, if it remains practical for your workflow, and keep a backup copy of the original workbook before making any changes.
You may also want to monitor the relevant Microsoft support article and future Office LTSC 2024 release notes for any updates or fixes.
If this is significantly affecting work in an organizational environment, your Microsoft 365 administrator can also open a support request with Microsoft Support through the Microsoft 365 admin center. This will allow Microsoft Support to collect diagnostic information and formally investigate the issue.
- For detailed guidance on how to open a support ticket with Microsoft Support, please refer to: Get support - Microsoft 365 admin | Microsoft Learn
- In case you do not know who is your IT admin, kindly refer to this article: How do I find my Microsoft 365 admin? - Microsoft Support
I hope this helps move the case forward. Should you have any further questions or need additional assistance, please feel free to share them in the comment below. I'm very happy to help.
If the answer is helpful, please click 'Yes' and kindly upvote it.
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.