Oct 13 2021 08:44 AM
HI
OS
Edition Windows 10 Home
Version 21H1
Installed on 9/15/2020
OS build 19043.1237
Experience Windows Feature Experience Pack 120.2212.3530.0
Device
Processor AMD Ryzen 7 5800X 8-Core Processor 4.30 GHz
Installed RAM 16.0 GB
System type 64-bit operating system, x64-based processor
Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20256) 64-bit
I managed to scope down the problematic portion of my working file to just this sheet, and surprisingly what cause my refresh all to freeze for several minutes is this simple query to a consolidate tables by appending the connections, in the early version of this file no problem at all, the refresh done instantly, not sure at which point and how this become corrupted?
this happen both in my work laptop and my personal PC (this one)
any idea?
Oct 13 2021 08:24 PM
Oct 25 2021 06:47 AM
SolutionOct 25 2021 06:47 AM
Solution