Desktop so slow in customer file

How big is your QBW file size?

4000 customers is a small customer list.  I've worked with files that have 100,000 customers and more that don't have any issue like this.

I wonder if your customer center / list is customized to show fields that are slow to load, or filtered in some way that makes displaying the list take a long time.

Once it displays, what fields are displayed?  Does it show All Customers, Active Customers, or something else?

Try making sure it shows "Active Customers" and that you do not see the little diamond highlighted below, which means the list displayed in a custom sort.  If you do see it, click on it to return the list to standard view (no sort).  Then close the window and try opening it again:

Does that help?

899852 K

We don't have a large amount of inactive customers.  When I browse the only columns I use are the Company Name, Start Date and Account #.  This is a mystery. 

---

@nancyl wrote:

899852 K

---

@nancyl 

You should be fine to run the file on your QB Desktop Enterprise. Run the Condense Data utility to remove old transactions (e.g all transactions prior to Jan 1, 2020) to isolate the issue. If you are still experiencing the same issue, consider to purchase a 3rd party file optimize service. It will copy all data into a new data file, remove unwanted temporary data, and audit trail data to bring down file size by 25-40%. This will improve the performance and stability of the data file.

Thanks so much! I'll try your suggestion.  

OK....

While you didn't indicate if your view of the customer center is as recommended, the other thing you might try is to re-index your names list.

To do this:

- Open a Check.

- Click in the Payee field and then press Ctrl-L. The Name List will appear.

- At the bottom of the Name List, click Re-sort list from the Name button.