Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
How to plot only visible autofiltered rows in a data list | Charts and Charting in Excel | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |