Why - All sheets affected by entry on one sheet - plus non-access to chart
Posted by Joyce on April 27, 2001 10:52 AM
I've run into this problem 3 times in the past few
weeks, all on different computers.
Basically, I'm going along fine, everything is working
as I would expect it to, and all of a sudden this
I enter new data on one sheet, or cut and
paste (either way) and the same data is entered on all
sheets. The only other interesting thing with this is
that any charts I have already made become inaccessable
when this happens.
I'm not sure what I've done that triggers the problem.
I believe twice this happened when I renamed a sheet,
but it may also be correlated to changing cells to
text only (under format, number).
It's driving me nuts. I can't seem to undo it. But if I
copy the cells into a new file, all is well again.
Anybody have an idea about what's happening here?