Failure phenomenon:
When a worksheet in Microsoft Office Excel 2007 contains many shapes, the pointer moves and scrolls slowly, and this problem occurs even if no shapes are visible on the current screen, how can you resolve it?
Reason Analysis:
This problem occurs because Excel 2007 will repaint all the shapes on the worksheet when you move the pointer. This problem can occur even if no shapes are visible on the current screen. As a result, automatic recalculation of the outer shape of the screen slows down the pointer and the scrolling response time. In addition, the more shapes in the worksheet, the slower the pointer moves.
Solution:
First, install the Office Excel 2007 hotfix package (Oart-x-none.msp, Oartconv-x-none.msp)
Second, by modifying the registry, enable the Patch:
Tip: It is risky to modify the registry, please back up important data in advance.
1, open Registry Editor, click Start, Run, type regedit in the Open box, and then click OK.
2, access to the registry entry: "Hkey_current_user\software\microsoft\office\12.0\excel\options"
3, on the Edit menu, point to New, and then click DWORD (32-bit) value.
4, type "Enablefastboundscalc", press "enter"
5, in the details pane, right-click Enablefastboundscalc, and then click Modify.
6, in the Value data box, type 1, and click OK.
Third, commissioning end, problem solving.
