software

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

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.