View Single Post
 
Old 08-27-2020, 03:51 PM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

As has been already pointed out, the best method is to setup a connection thru power query.

Import the First Sheet in a Workbook with Power Query - Excelerator BI
Reply With Quote