Excel 365 - Import .csv without creating a table

Hello everyone! I previously used Excel 2016 with importing large .csv files. This method did not automatically create a table. With O365 I am seeing that the new import method automatically creates a table (unless you choose the legacy import option). I have found that this table causes my formulas to not work. I discovered that I can copy the entire sheet's contents, paste into another sheet and the table goes away.

Is there a way to import using the new O365 method but not create a table?

Nope, via Get Data you will always get a table. Maybe you could show the issue. I am sure it could be fixed in your formula

Thank you JEC. An example of the formula I'm using is:

Formula:

Please Login or Register  to view this content.

I don't understand why a table would interfere with formulas (there are others that I use that also don't work. It basically crashes Excel). When I remove the table, the formulas work perfectly as they did in O2016. I am not a big Excel user and don't truly understand what a table even is.

I don't think this one is the issue. Are you using heavy array formula's on whole columns? Maybe post a sample file if you could

Can't really post a sample. The Excel document I run these formulas on are 40,000+ rows with approximately 15 columns.