Steps to reproduce the problem.
1. Have some VBA Project that opens automatically when excel is started (this could be a personal macro workbook, or a plugin like Macabacus or Arixcel that adds a VBA project into the developer console).
1. Create blank workbook
2. On the first sheet freeze the panes. It doesn't seem to matter where.
3. On the second sheet add a form or activex control. As far as I can tell, any control will cause the problem.
4. Still on the second sheet, reference a cell on the first sheet from any cell. Before pressing enter, rapidly press your arrow keys to get the reference box (aka marching ants box) to move around the screen quickly.
In my experience the box will lag, sometimes quite substantially. The more data you have in your workbook the worse the problem will be, so even though it might not seem like that big of a problem in this simple example, it gets substantially worse once you get workbooks that are 3MB or greater.
Any ideas as to what causes this? How/if it can be fixed?
1. Have some VBA Project that opens automatically when excel is started (this could be a personal macro workbook, or a plugin like Macabacus or Arixcel that adds a VBA project into the developer console).
1. Create blank workbook
2. On the first sheet freeze the panes. It doesn't seem to matter where.
3. On the second sheet add a form or activex control. As far as I can tell, any control will cause the problem.
4. Still on the second sheet, reference a cell on the first sheet from any cell. Before pressing enter, rapidly press your arrow keys to get the reference box (aka marching ants box) to move around the screen quickly.
In my experience the box will lag, sometimes quite substantially. The more data you have in your workbook the worse the problem will be, so even though it might not seem like that big of a problem in this simple example, it gets substantially worse once you get workbooks that are 3MB or greater.
Any ideas as to what causes this? How/if it can be fixed?
