help on VBE
I have an Excel workbook that has a pivot table, the pivot database is referenced by the name ´my_data´ , the data is a large table, stored in CSV format. If I copy the table to the workbook, and give the range the name ´my_data´ it´s working ok, but I want to avoid copying the data to the workbook, and to make ´my_data´ point to the CSV file itself, I did that but when I try to refresh the pivot, it says that the reference is not valid. what am I doing wrong ?
I have an Excel workbook that has a pivot table, the pivot database is referenced by the name ´my_data´ , the data is a large table, stored in CSV format. If I copy the table to the workbook, and give the range the name ´my_data´ it´s working ok, but I want to avoid copying the data to the workbook, and to make ´my_data´ point to the CSV file itself, I did that but when I try to refresh the pivot, it says that the reference is not valid. what am I doing wrong ?