Forum Discussion
Excell Changed after Update version 1703 for Windows 10 - Not Happy
Hi Aaron,
To prevent creating the table uncheck in File->Options->Data the option "Prefer the Excel Data model...":
Alternatively, when you import text file
on final stage you most probably see like with checked "Add this data..." and when it creates the table
Just uncheck it
and your data will be imported in "old style", without the table
Ok figured out how to fix the issue, although I will say this should not have happened to begin with, or at the very least give me the option to do either or instead of burying it.
To get Data> From Text/CSV to import like before go to File>Options>Data then select the box From Text (Legacy) then press ok. Once you have your file open and are under the data tab, Next press the Get Data>Legacy Wizards from the drop down menu then press >From Text (Legacy) and boom imports like it did previously.
Honestly, if they want to introduce something new please do, just give us the option to either enable it or disable it. Especially when it comes to data import options. I literally almost missed a $30,000 project because of this.
Aaron BARR Thank you!!! I was so frustrated with the new data import feature. It worked great before and I have no idea why they changed it. I was so relieved when I followed your instructions and it worked like before.