Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Excel 2007 - I put a number in cell B1 one sheet 1 and it automatically also puts it on B1 on sheet 2 - need this to stop

Ok, I have an excel 2007 file and say 3 sheets sheet 1 sheet 2 sheet 3

When I put information into a cell on say sheet 2, the info also appears in the same cells on sheet 1 and sheet 3.   Never seen this before, need it to stop - help!
0
dbllp
Asked:
dbllp
1 Solution
 
Randy DownsOWNERCommented:
You probably already did this but if not restart Excel & then the PC.
0
 
HainKurtSr. System AnalystCommented:
close it and open new file
if it continues, press ALt+F11 to see whteher there is a global macro running...
0
 
TonyWongCommented:
Are the sheets Grouped?

On the sheet tabs on bottom of the screen, right click on one of the tabs and select 'Ungroup Sheets'.
0
 
jppintoCommented:
If your sheets look like the attached image, then they are grouped. Right-click on top of one of the Sheets name on the tab and select "Ungroup Sheets".

jppinto
Capturar.JPG
0
 
dbllpAuthor Commented:
Thanks, I am an Excel dummy and this was the issue.  Guess my end users need some training too!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now