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
After it loads as a table, look at the ribbon and choose convert to range. It takes it out of the table. See attached.
Personally, I love working with tables. There are a lot of positives with using them. You may want to try them out sometime.
Also, the subtotal formula is only summing whatever is in the table column. It changes when data is filtered, but unfiltered data is still a complete total.
Jean,
Thanks for the reply and yea I tried that and it did nothing. The table still remains. If the formula's worked each and every time it would not be an issue so much but the new import option does not allow the formula to function properly each time.
The table option is really nice and I do use it when it's called for, however, the way I needed it to function was completely changed. That was the primary issue. I was able to figure out how to revert it to the legacy process but still caused me to loose alot of time and like I mentioned, it almost cost me a $30,000 contract in the process.