Results 1 to 4 of 4

Thread: Split worksheets.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Split worksheets.

    When I split a worksheet, I lose all of the calculations/data validations that were on the original worksheet. Am i doing something wrong or is it something I will just have to deal with.

    .

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split worksheets.

    Only the raw data values are extracted when using this function so formulas are converted to their values in the resulting sheets.

  3. #3
    New Member
    Join Date
    Oct 2009
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split worksheets.

    I'm not sure I understand. Actually, I am quite sure that I don't understand your comment!

  4. #4
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Split worksheets.

    Quote Originally Posted by ou81aswell View Post
    I'm not sure I understand. Actually, I am quite sure that I don't understand your comment!
    Hi

    That was a spam post. Spammers rarely make much sense in their posts. All they are trying for is to get links to their customer sites out on the web as much as possible.

    I've banned the spammer and removed the post.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

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
  •