Connections to External Data & Filtering Extremely Slow--High CPU Usage!

hengishammer

New Member
Joined
Feb 7, 2019
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Hello all!
I am using Office 365 version 2108 (Build 14326.20962) 64 bit. System Specs: Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz 2.29 GHz 16.0 GB.

I had a couple of connected workbooks that worked great until I had to tweak some data. I went in to change an existing connection to a newly created tab in the target workbook. Once I did that--the connection went to crap. I noticed that "Loading .NET Framework" appeared in the bottom right hand corner as well as running background query appeared in the left hand corner bottom. Also, the thread calculation was showing and it is TAKING FOREVER to pull definitions down, when before it was a 3 second exercise. My data was housed on a network drive, and anyone in the company could refresh the data connection and pull down the newest info. (xlsx to xlsx.) The data being imported is just flat data.

Second thing: Filtering in this sheet is now a nightmare. Yes, I have formulas in this sheet. They are Index/Match formulas and worked great previously. Now it takes forever and the bottom right hand corner is constantly calculating the threads. So, after much research, I rebuilt the whole workbooks from scratch. I reset the connections and rehoused them. I reset all formulas, and it's doing the exact same thing. I trimmed down the 19,000 lines of formulas waiting for input from other cells to just 3500 lines. Still slow. CPU usage goes through the roof--fan kicks on too. Add-ins are all disabled.

I even moved the 2 workbooks to my desktop and tried making the connection there and its super slow.

I even wiped my whole system, started with brand new windows install, and brand new office 365 installation.

I am super stumped and #$%#$ frustrated--been working on this for a whole week already. My hunch is this is due to an update.

The old version works great! But my data changed and I need to route it differently now. I am attaching some examples of formulas, the connection methods--the tabs I am importing.

Any help shedding light on this besides the canned "did you update Microsoft Office to the latest update?" would be most helpful....
 

Attachments

  • Screenshot 2022-05-25 202822.png
    Screenshot 2022-05-25 202822.png
    5.7 KB · Views: 7
  • rfrfrf.png
    rfrfrf.png
    15.5 KB · Views: 7
  • name.png
    name.png
    39.5 KB · Views: 7
  • clientref.png
    clientref.png
    41.2 KB · Views: 8
  • emp num.png
    emp num.png
    33.6 KB · Views: 8
  • connection method.png
    connection method.png
    60.8 KB · Views: 7

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top