changes across all worksheets
Eliminate Pivot Table Annoyances
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
    81,751
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 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.

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
  •  

 

 
DMCA.com