respond

Hi, I have a 60MB workbook that takes 8+ minutes to open on my quad core laptop. It opens only using a single core (20%cpu). After the workbook opens the first few adjustments I make causes the Excel to hang and takes a few seconds (3-5) to respond. After I save the initial edits it's faster...

Hi All I need to unzip a file by a keyword of a file since the file name contents some variable numbers and dates which are varied with the date. Therefore I tried to create a code to unzip a file by its keyword. I tried to use a function with a sub but it does not respond me. How do I fix...

Just wondering if anyone knows the story behind the &#x2605 user name prefix. All of the threads that I have viewed that use that prefix seem to be homework type questions and I am hesitant to respond to them. The latter part of the name varfies from thread to thread but the &#x2605 is always...

Hi there, I'v got this realy weird situation that one specific sheet in a workbook that does not respond anymore to changes in the format. Here's a screenshot of sheet 1 in the workbook. The cell A1 contains the time 16:50:00. The cell is formatted to show time in hh.mm and this works fine...

Hi, Sometimes when I toggle from other applications into Excel, it takes a couple seconds for Excel to respond to the initial click. This only happens on the initial click into Excel. After that it works fine. This issue isn't limited to one file, either. It seems to happen to all of the...

Hello friends, hope all is well! My Excel hangs/freezes/doesn’t respond, when I apply the below formula on more than 100,000 rows. How to apply the formula without the above issues? Can it be done via powerpivot? What dax formula can I use? =COUNTIFS($D$5:D5,D5,$E$5:E5,E5,$F$5:F5,F5) Thank...

Running Excel 2016 I have this formula in cell G8 which is working, =IF(F8="","",ABS(D8*(1-F8)-D8)) Cell F8 is percentage/% formatted Cell D8 is accounting formatted with a entered/fix $ value With this formula is there any way for cell G8 to ignore zero? Thank you for all who respond...