A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This IS REPEATABLE - and seems specific to Excel 2013.
System: Intel Core i7-3820 @ 3.60 GHz, 12 GB RAM
OS: Windows 7 Ultimate 64-Bit with SP-1
OFFICE Installations:
Office 2003 Pro (32 Bit)
Office 2010 Pro Plus (32 Bit)
Office 2013 Pro Plus (32 Bit)
EXCEL 2013: When I go through your process things seem fine until I move the visible group. At that point CPU usage jumps from 1 or 2% to up around 30%. Task manager confirms it is Excel that is eating up the cycles. If I make the hidden pair visible again, CPU usage again drops to 1 or 2%. Hide them, move the other, and we are back up to steady 30+% usage.
The Disable Hardware Graphics Acceleration setting does not alter the results in any fashion.
EXCEL 2010: Same machine, same setup - same actions: CPU usage never goes up except momentarily when I move the visible group on the sheet.
I have no clue what you'd do to work-around it in 2013; it seems to fall into the category of "if it hurts when you do that, don't do that". And I personally would find that an unacceptable answer.