Sometimes data will jump rows randomly.
On a certain document, about 4 mbs in size, when I exit the document all of
the data will be where it should be. The next time I open it some of the data, randomly, will jump rows never columns. Somtimes 2 rows but occasionally up to 20. We have gone through and resorted the whole thing about three times now. What could be the cause and possible solutions? Thanks, J |
Sometimes data will jump rows randomly.
Your spreadsheet may have a macro that performs a row insert when a
particular spreadsheet event occurs. It may be set up to occur when you enter or leave a particular cell or particular range of cells, or when a certain cell is a certain value, or some other condition is true, for instance. You can check this by pressing ALT-F11 to open the VBA editor. In the Project pane along the left margin of your screen, find the VBAProject associated with your spreadsheet name. There is an icon tree for each tab in the workbook, and for the workbook: right click on each icon and click View Code- this is where event macros are stored. The event triggers will be called something like SelectionChange, Change, Deactivate, etc. Look for the command Insert, and investigate the source and rationale for that macro. |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com