MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
problem begins...

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?

Thanks much!!


Posted by Barrie Davidson on April 27, 2001 12:00 PM

When you enter your data (or cut and paste) do you have all the sheets selected? If you do, anything you input on the active sheet will also be inputted on the selected sheets.

Barrie.

Posted by Joyce on April 27, 2001 12:07 PM

Also - Many toolbar buttons are not clickable
like sort and create-chart. Nor can these
operations be done with the pull-down menus.

Grrrrrrr.....

Posted by Joyce on April 27, 2001 12:08 PM

No, not that I'm aware of. It doesn't appear to be the case.

Posted by Barrie Davidson on April 27, 2001 12:11 PM


You can tell if you have more than one sheet selected if more than one sheet's tab (at the bottom of the window) is white, not grey. Grey tabs are sheets that are not selected.
Does this help you?

Posted by Joyce on April 27, 2001 12:25 PM

You can tell if you have more than one sheet selected if more than one sheet's tab (at the bottom of the window) is white, not grey. Grey tabs are sheets that are not selected. Does this help you?

Yes, I figured that out and found that they are
not all selected. So I selected them all just to
be sure. One major difference is that if I select
all sheets (in a new file entirely) and enter
data - it *does* appear on all sheets, but I
would need to reselect all sheets to do anything
else to all the sheets.

Maybe - just maybe - this problem is limited to
files that *originated* on one particular zip disk.
I'm pretty sure that each time this problem has
occurred, it has happened to files that were begun
on this disk. Although, it occurred one time after
I had copied a file from this zip disk onto a CD,
and used this CD in my home computer - where the
problem occurred.

This zip disk was bought as a Mac formatted disk,
and I reformatted it to IBM. Hmmmmm... It has only
been used in an IBM-compatible machine.

I'm trying to think of any and all possible
reasons this is occurring - because it's pretty
frustrating and I'd like to prevent it from
happeneing again.

Joyce

Posted by Barrie Davidson on April 30, 2001 1:00 PM

I'm stumped!

Sorry I can't come up with a solution for you Joyce. If you do end up with one please let me know what solved the problem for you (I'm very curious now also).