I have a file with a connection to an excel file. I want to copy V random excel data from another excel sheet and have it open as a separate data connection. Every time I do it, it tries to combine with current data or if I remove current data table and then copy V, it shows the old dimensions as missing. How do I get around this?
Go to a new sheet and then copy and paste new data.
Let me know if this works.