respond

  1. A

    Speed up Excel when opening and first editing

    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...
  2. N

    How to unzip a file by a keyword

    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...
  3. JLGWhiz

    multiple users with same user name prefix

    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...
  4. T

    Sheet does not respond to format changes

    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...
  5. B

    Excel Slow to Respond ON FIRST CLICK into the application

    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...
  6. countryfan_nt

    hangs/freezes/doesn’t respond.

    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...
  7. J

    Ignore "ZERO" in a Cell

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top