Results 1 to 9 of 9

Thread: How can I link to a large table in another excel file ?

  1. #1

    How can I link to a large table in another excel file ?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    The traditional copy in one excel workbook and paste in the other excel workbook does not work. We are talking about a huge table (37000 rows and 77 columns)
    I want to create different excel files with reports for different target audiences based on this data in the master excel file.
    Does anyone know how I can realize this?
    Regards
    Els

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    This sounds perfect for MS Query;
    On the Data tab of the ribbon, in the Get External data section, choose From other sources, choose From Microsoft Query, in the resulting dialogue box choose Excel Files*, navigate to your data file, choose the table (and the columns you want to include from it) in your report, in the next steps choose how you want to filter and sort the report, and in the last step, choose whether to return the data to excel, or fine tune the query in MS Query. That's it.

    The data file doesn't need to be open.

  3. #3

    Unhappy MsQuery does not work (yet)

    Unfortunately I get the message "This datasource contains no visible tables" using MsQuery. I have already renamed both table and worksheet to "database", but this did not fix the problem neither

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    Don't you even get the sheet names appearing?
    What version of
    1. Excel are you using to try and grab the data?
    2. what version of Excel is the datafile saved as?

    I tried here with an Excel .xlsx file with just some data and headers in a sheet, no names, no Excel Tables, saved it. Then tried to MSQuery it from Excel 2010, it saw the headers straight away.

  5. #5
    I also use excel 2010

  6. #6
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    Well that's a surprise (that it's not working).
    Perhaps we can do some remote assistance with the likes of TeamViewer?

  7. #7
    I have installed TeamViewer, how do we proceed from here

  8. #8
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    OH, right, will Private Message you here straight away.

  9. #9
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    Given up?

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
  •