Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: changes across all worksheets

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Some how i changed the settings in a notebook and now when i enter data in one worksheet, the same data is entered in all the other worksheets. How did i do this? How can I get rid of it?


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,632
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-24 15:37, seharris wrote:
    Some how i changed the settings in a notebook and now when i enter data in one worksheet, the same data is entered in all the other worksheets. How did i do this? How can I get rid of it?

    You probably grouped all the worksheets of your workbook. Give a right click on a tab of a worksheet to see whether they are grouped. if so, ungroup them.

    Just a thought.

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i tried right clicking on the sheet tabs, but nothing about grouped worksheets is there. any other advice?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    maybe a silly question, but did you actually click on the sheet name itself (ie not on the sheet somewhere)? are all the sheet tabs white or is just one white and the others grey? if they are all white it should mean that the sheets are grouped, and by right clicking on the sheet tab you'll get a shortcut menu, the top item of which will be 'ungroup sheets'. if you don't get this on the menu it probably means your sheets aren't grouped but if that's the case,beyond sheet corruption or some vba code (you can see this by right clicking on the sheet tab and selecting 'view code' from the shortcut menu) which is making it behave this way i can't see why this is happening.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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