+ Reply to Thread
Results 1 to 2 of 2

Excel sort in Office 2016

  1. #1
    Registered User
    Join Date
    09-06-2018
    Location
    Jacksonville, Fl
    MS-Off Ver
    2016
    Posts
    1

    Excel sort in Office 2016

    First, I am not an excel expert but an IT admin. Just moved a user from Windows 7 to Windows 10 64bit, fresh install, same machine. The old install was running Office 2010, the new install is running Office 2016 32bit. A simple sort of a field on the same file exported from SAP NetWeaver takes considerably longer. I have checked filters, cleaned excess formatting, etc.... All the default settings for Office 2010 Excel and Office 2016 Excel are the same. Not sure if its Windows 10 or Excel 2016. Maybe the way a sort simple was changed in Excel 2016? Comments welcome.

  2. #2
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Re: Excel sort in Office 2016

    Some things I would try...

    1) Find the range that Excel thinks has data by clicking on cell A1 and then press CTRL+END.
    2) Clear all filters
    3) Clear format (Home, Editing, Clear, Clear Format)
    4) Check to see if there are any macros and when they run (ALT+F11)
    5) Make sure you have the latest Windows and Office updates

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel & office 2016 for £10 ???
    By Trebor777 in forum Excel General
    Replies: 2
    Last Post: 10-31-2017, 02:39 PM
  2. Replies: 1
    Last Post: 12-18-2016, 11:47 PM
  3. Replies: 1
    Last Post: 08-07-2016, 05:52 PM
  4. [SOLVED] Code not working in Office 2010 and Office 2016
    By amitmodi_mrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2016, 02:48 PM
  5. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  6. Conditional formatting with udf issues with Office 2016 / Office 365
    By andikeep2580 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2016, 10:58 AM
  7. Default excel template in Office 2016?
    By honeybadger_rgr in forum Excel General
    Replies: 0
    Last Post: 12-10-2015, 12:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1