S
Stacey
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????
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????