Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Default Size of Excel workbooks limited??

    I've got large Excel workbooks with up to 20 worksheets.
    What do I have to do to check all worksheets?
    Because sometimes it may happen that only the first sheet is checked. In smaller files it seems to with up to 2 worksheets,

  2. #2
    Join Date
    Oct 2007
    Posts
    437

    Default

    The built-in support for Excel workbooks uses the Data Compare and only extracts the text from the first worksheet. You can download the "Microsoft Excel Workbooks" file format at http://www.scootersoftware.com/v3formats which uses the Text Compare and extracts the text from all worksheets. Let me know if you need instructions on how to extract the text from all worksheets using the Data Compare.
    Erik Scooter Software

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    Default

    Hi Erik,

    thanks for the quick response. Sorry for my late response.

    I've used the plugin but it did it not correctly. The rows are scrumbled. Some rows are missing, some are at the end. And it looks like as BC only compared the first sheet.
    Are there any known issues about that?

    Regards
    Matthias

  4. #4
    Join Date
    Oct 2007
    Location
    Pennsylvania
    Posts
    1,772

    Default

    By its very nature, a data compare will reorder the rows by sorting by columns with keys. To see the data in the same order as the spreadsheet, you need to go into session settings and check the "Unsorted Alignment" checkbox.
    BC v4.0.7 build 19761
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

  5. #5
    Join Date
    Aug 2008
    Posts
    3

    Default

    Thanks, Michael.
    That hint helped. Now the rows are in correct order. But I can only see the first sheet which depends on the data compare.
    It helps me more to use the "MS Excel Workbooks With Formulas". The look is not that nice as in the data compare "MS Excel Workbook" but this compare looks through all sheets.


    regards
    Matthias
    Last edited by matthiass; 01-Sep-2008 at 03:00 AM.

Tags for this Thread

Posting Permissions

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