News for hackers. Stuff that matters.
Re:Like MS Excel, Pivot tables never die by NetMageSCW on Thursday October 16, 2025 @10:50AM (#45606083)
That can be turned off (easily Googled), or as mentioned, doesn’t affect proper import using Power Query. Also, if you control the data format and know Excel is the intended target, you can just output your CSV so Excel won’t do that (put =“ and “ around text columns).

For any spreadsheet which are updated by refreshing source data such as CSV output from other systems, PowerQuery is what should be used and is very effective.

Re:Like MS Excel, Pivot tables never die by epistasis on Thursday October 16, 2025 @02:52PM (#45609234)
What are the web search terms you use to find to turn this off? Most people have not been able to figure this out, with the help of the web or in the application itself.

The typical windows user is not going to be accomplish a successful import, except maybe by whatever the heck PowerQuery is.