I have a table of data in File_1.xlsm that I want to export into into File_2 via a data connection, since I update the data in File_1 often and want to import it into File_2 at the click of a button.
I've tried every permutation I can think of in the Data Connection dialog, but I can't get it to just pull in the raw values. It will only import the data as a TABLE, with a header row (with filter arrow!) and a bunch of unwanted table formatting. I just want the values, no header row, no filter arrows, no formatting. The 1st pic below is File_1 (source file). 2nd pic is File_2 (destination file, with the ugly formatting I can't seem to avoid.)
Feels like it shouldn't be this hard, but I'm striking out. Any suggestions? FWIW
- File_1 has to be a .xlsm file, it can't be a CSV, otherwise I'd know how to do this.
- I thought about just using formulas in File_2 to refer to the static cells in File_1 but I really want to avoid any external file linkages between workbooks in the formulas themselves; they've caused headaches in the past.
I've tried every permutation I can think of in the Data Connection dialog, but I can't get it to just pull in the raw values. It will only import the data as a TABLE, with a header row (with filter arrow!) and a bunch of unwanted table formatting. I just want the values, no header row, no filter arrows, no formatting. The 1st pic below is File_1 (source file). 2nd pic is File_2 (destination file, with the ugly formatting I can't seem to avoid.)
Feels like it shouldn't be this hard, but I'm striking out. Any suggestions? FWIW
- File_1 has to be a .xlsm file, it can't be a CSV, otherwise I'd know how to do this.
- I thought about just using formulas in File_2 to refer to the static cells in File_1 but I really want to avoid any external file linkages between workbooks in the formulas themselves; they've caused headaches in the past.

