I’m trying to import a CSV file that has dropdowns, those dropdowns are referencing some cells that are looking up information. When I try to import the file it doesn’t import, I have been troubleshooting and came to the conclusion that its the referenced cells but I can’t get rid of them as they are needed to make the dropdowns work. Any ideas on what I can do to fix this issue? I have hid the cells far under the page to the 50,000 row but have had no luck.
Any help will be appreciated!