Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000, Duplicate Information

    This is rather vague, but anyone have information about a problem wherein certain cells of information typed in one worksheet appear in many other worksheets? The problem occurred for a user and I don't know what they were specificaly doing aside from typing in info.

    It's a single row of information that's duplicated; however, not EVERY cell in the row is duplicated...only the cells that contain unique information in the worksheet are duplicated across the worksheets (i.e., there are 3 or 4 columns that contain the same info in all cells, such as client name, and this same format is applied on all worksheets).

    The workbook has about 40 sheets, and 14 sheets are affected by the problem. There are no macros in the workbook, though there are many calculations on one sheet that reference information on other worksheets.

    Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000, Duplicate Information

    What you are describing can happen if you have more than one sheet selected when you type data. For example, if you hold down the Ctrl key and click on several of the worksheet tabs, all of those sheets will become selected. Then anything you type on the active sheet will also appear in the same cells it all of the other selected sheets. Also, if you hold down the shift key and click on a sheet tab other that the active sheet, then all sheets between the active sheet and the one clicked on will be selected (this is sounds like what might have happened). Again, anything typed in the active sheet will appear in all selected sheets.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000, Duplicate Information

    Wow. How did I not know that? Thanks for the education!

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000, Duplicate Information

    If we all knew everything, then there would be no need for places like this! <img src=/S/smile.gif border=0 width=15 height=15>
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000, Duplicate Information

    Fair comment! I like it.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •