Maximize your protection, eliminate business risks.
Optimize and modernize with cloud transformation.
Empower your people to work securely from anywhere.
Let us handle IT so you can focus on growing your business.
Get multichannel 24/7/365 expert end-user support.
Protect, detect, and respond—Dataprise keeps your business secure.
Maximize uptime with with industry-leading DRaaS.
Swiftly mitigate cyber threats and restore security.
Improve efficiency, productivity and outcomes with cloud.
Ensure all mobile devices, everywhere, are secure.
Gain a competitive edge with strategic IT solutions.
This battle-tested checklist enables your team to swiftly initiate a ransomware response.
IT for businesses of all sizes, in any industry.
Empower institution growth with custom IT solutions.
Ensure your firm is always in compliance.
Improve patient care and staff morale.
Deal with pressing legal matters, not IT.
Keep up with the evolving digital landscape.
Focus on your mission by outsourcing IT.
Accelerate PE client deals and secure data.
Empower Your Municipality with Secure, Reliable IT Services
Execute initiatives and develop IT strategies.
Get the latest industry insights and trends.
Join us at events in person and online.
Hear from clients and learn more about strategic IT.
See how Dataprise can make IT your greatest asset.
Get informative technical resources from IT experts.
Stay on stop of emerging cybersecurity threats.
Discover the key areas of DR your organization needs to address to ensure downtime is minimized.
Gain a strategic asset by bringing harmony to IT.
Ensure 24/7 support and security with dedicated teams.
Drive business forward by partnering with Dataprise.
Meet our one-of-a-kind leadership team.
Discover the recognition Dataprise has earned.
Help us help businesses with strategic IT.
Grow through acquisition and partnership with Dataprise.
Embracing different perspectives and backgrounds.
Find a Dataprise location near you.
Dataprise is committed to empowering more women to consider a career in technology.
Explore our trusted partnerships with leading tech innovators.
Posts
By: Stephanie Hamrick
Table of content
The ‘tyranny of default’ in the IT realm is a concept where changes are forced upon users by heavy handedly offering new ways of doing things they were able to do before.
Today on the blog the victim is Excel and the recent (maybe not quite that recent – June 2017 version 1704 ) update to O365 that introduced a new ‘Power Query’ wizard. Personally, my use of Excel is limited to parsing CSV files and reading log files, so I find the concept of pivot tables about as exciting as reading Windows Event Log.
Bad news is the new wizard replaces the old one, and you will have to do some digging to get this turned back on. Oh it’s in a new spot in the interface too, you’re welcome.
The following describes how to use the basic CSV import utility prior to 1704
Here is the version of office used in the steps above.
Final Thoughts: The old (legacy) wizard is still there and remains unchanged; it’s merely changed its position in the UI. Group Policy ADMX files do not currently exist to manage this setting and re-enable the old wizard, so your users need to take action to get to the legacy wizard. I secretly suspect this is a registry flag that is being flipped, but was not able to find any workarounds to manage this setting. Will update this post if a solution is found.
JacobR, PEI
INSIGHTS
Subscribe to our blog to learn about the latest IT trends and technology best practices.