Results 1 to 5 of 5

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

  1. #1
    Board Regular ExcelFanatic's Avatar
    Join Date
    May 2009
    Location
    Coronado, CA
    Posts
    83
    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.
    Excel Fanatic

  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

    For performance reasons, only the values are copied. Formatting and formulas are ignored. I'll look into what is involved with improving this in a future update.

  3. #3
    Board Regular ExcelFanatic's Avatar
    Join Date
    May 2009
    Location
    Coronado, CA
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split worksheets

    Thanks for the information. I hope to see it in a future release.
    Excel Fanatic

  4. #4
    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

    I just checked and realized that the software is simply using range.copy's to split the sheets. This should (and does with my sample data) copy over formatting and formulas so perhaps I'm not understanding the original question fully.

    Could you send me an example workbook that demonstrates the problem so that I can see it first-hand?

    Please send it to me via email: support at easy-xl.com

    Thanks.

  5. #5
    Board Regular ExcelFanatic's Avatar
    Join Date
    May 2009
    Location
    Coronado, CA
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split worksheets

    After your last email. I went back and tried it again. You are correct! All the formulas and data validations are there. Don't know what I was doing wrong before.

    I do however have another problem. I am trying to use the Summarize/Pivot utility. Some of my columns have dates in the headers and when I run the utility all I see is current date.

    No matter which column I chose to summarize on (or even if I chose all of the columns), the result only shows the data for the last column.

    I am emailing you a copy of the data for you to review.

    Thanks
    Excel Fanatic

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
  •