I have a massive spreadsheet that I use with a partner to communicate catalog
data. The cell data seems to randomly switch locations within the
spreadsheet. For example, I have a column for Name and a column for
Description with correct values. After navigating the spreadsheet for awhile
I'll come back and discover that a Description value is now populating a Name
cell. I have no macros and no formulas in this spreadsheet. I've tried
creating a new sheet and doing a paste special of just the values, but it's
still happening. It does seem to happen more often if I have multiple
spreadsheets open, but I'm not sure that isn't because I'm using it more at
those times as well. Any ideas????