Hi Pete,

Thanks for your suggestion. We have had that happen before so we try to
avoid inserting new cells. If we enter new data we tend to add it to the
bottom of the spread sheet and then 'sort' the data. Obviously I can't rule
your theory out entirely, but I wonder if there is another explanation?

"Pete_UK" wrote:

Perhaps someone Inserted some cells, not realising that this action
would move other cells over into another column.

Pete

On Jul 23, 11:39 am, CW wrote:
Good morning,

I wonder if somebody can help me? I am working on a large Excel spread sheet
containing c.20000 rows of data across 28 columns. The cells contain prices
that have been entered in the currency format. The spreadsheet is in regular
use and is often being edited, however it appears that some of the pricing
information is moving between the columns. For example a chunk of data that
was originally entered into column x seems to move into column y or z. This
appears to happen at random and the moving of data is not being performed
intentionally, (I am pretty certain of this as the people responsible for
editing the spreadsheet are also responsible for performing the amendments!).
The spreadsheet is sorted by column headings and we are using the 2000
version.

Any thoughts, comments, or suggestions would be really appreciated.

Many thanks