The company I work for updated to Office 365 about a year ago. Previously I use to be able to create a data connection to a .csv file that would load the data to a workbook sheet via a macro. Then I could use helper cells referencing the loaded data to automatically create summaries. With the new version, it seems I can only import data as a table or pivot. If I import this way, my formulas loose their reference. If I choose "Load To" and create connection only, the data is not loaded into a sheet where I can use it. I'm sure there is something simple I'm overlooking, any help would be appreciated.
Thanks!
Bookmarks