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

Els G

New member
Joined
Jun 24, 2014
Messages
4
Reaction score
0
Points
0
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
 
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.
 
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
 
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.
 
Well that's a surprise (that it's not working).
Perhaps we can do some remote assistance with the likes of TeamViewer?
 
I have installed TeamViewer, how do we proceed from here
 
OH, right, will Private Message you here straight away.
 
Back
Top