![excel 2016 slow search excel 2016 slow search](https://www.imymac.com/images/technology/font-book-fix-excel-running-slow.png)
The only thing that takes ages is opening and saving.
![excel 2016 slow search excel 2016 slow search](https://www.get-digital-help.com/wp-content/uploads/2009/12/Lookup-a-value-and-find-the-latest-date.png)
![excel 2016 slow search excel 2016 slow search](https://cdn.ablebits.com/_img-blog/shared-workbook/share-workbook-multiple-users.png)
It responds well to scrolling, filling the cells in, etc. NOTE: working with the spreadsheet once it's been opened is fine.
EXCEL 2016 SLOW SEARCH PC
Kill excel and restart the PC (somehow opening takes a bit less time at first).Identify the Excel's directory within the AppData and remove all the temporary files.Disable synchronise (One Drive for Business, Evernote, Sharepoint, etc).Remove all the objects (icons, pictures, etc) from external sources.Switch off auto-calculations and auto-recovery.Close all the connections I could identify through the Excel Interface (Edit Links, Show Queries) - copied and pasted all the data sets pulled from SQL as text and removed the queries.The pivot tables themselves take quite a lot of memory BUT it wasn't an issue in the previous versions of Excel - I have always used tones of them and never the file has been so heavy to open/close. The data from the DB are used to populate pivot tables. It's an interface for pulling the data directly from the database (SQL Server). Excel 2016 is fitted with a new functionality called usually Power Query. I am using MS Office 2016 version on Windows 10. For some time now I have been experiencing problems with the Excel files I work With.