I have a worksheet called raw_data
where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv
.
However if I try to create a table on another worksheet data
i am not able to reference the name-referenced range abc.csv
.
How can I convert this named range into a table without loosing the data-connection?
Steps to reproduce:
- Have a csv-file.
- Import it with the wizard.
- Check name in name-manager.
- Create new worksheet.
- Create table via wizard and enter the name of your imported data-range