Hi all
I am having a problem with creating workbook connections to input worksheet data from different workbooks into a dashboard workbook.
There are three workbooks I am connecting to each with multiple worksheets. The worksheets each have an identical structure, row 1 of each worksheet on all the workbooks has no data in it.
When I create the connection some tables that are imported have the empty row as the first (header) row of the table, while others miss the empty row out and draw from source row 2. When I delete and repeat the exercise of connecting excel is consistent in either including or excluding the empty row one dependent on which worksheet I am connecting to. As the workbooks are exported in the format they are from a database there is no way for me to change the structure.
I would welcome any ideas on what is happening and how I could overcome the issue!
Many Thanks
I am having a problem with creating workbook connections to input worksheet data from different workbooks into a dashboard workbook.
There are three workbooks I am connecting to each with multiple worksheets. The worksheets each have an identical structure, row 1 of each worksheet on all the workbooks has no data in it.
When I create the connection some tables that are imported have the empty row as the first (header) row of the table, while others miss the empty row out and draw from source row 2. When I delete and repeat the exercise of connecting excel is consistent in either including or excluding the empty row one dependent on which worksheet I am connecting to. As the workbooks are exported in the format they are from a database there is no way for me to change the structure.
I would welcome any ideas on what is happening and how I could overcome the issue!
Many Thanks