infinite

I'm using the following macro to suppress messages about there being things within the workbook that the document inspector can't remove. It works but when closing the file it enters an infinite loop of saving and then prompting me if I want to save changes. How could I exit this loop after...

Good Afternoon, I have an excel workbook in which there is a pivot that is connected to power BI. When I attempt to refresh this pivot I get stuck in an infinite refresh loop forever. It just says the following things over and over again: Running OLAP query Refreshing the OLAP cube Waiting...

I currently have a macro stuck in an infinite loop! I've done Alt/Esc about 3 times and it's not breaking out. I tried Ctrl/Esc, Alt/End and Ctrl/End & it isn't helping. Anybody have any ideas? Thank you!!

Here's the setup. I can send the spread sheet over as well. Column A: Listed vertically an infinite amount: Harden, Westbrook, Jokic, George, Irving, Mitchell, Gobert, Walker, Gasol, Faried Column B: Listed vertically an infinite amount: Salary associated with player in column A: 12900, 11000...

If I step into this code, it seems to be stuck in an infinite loop, yet if I run it, it's fine: Option Explicit Private Sub cmbGraph_Change() Me.cmbGraph.Clear Me.cmbGraph.List = Array("a", "b", "c") Application.EnableEvents = False Me.cmbGraph.ListIndex...

I have an existing workbook that has some links in it. These are links that I did not intend to have. When I open the workbook I keep getting the message "MS Excel cannot access the file "http://.... .. ". Please make sure you are using the correct address. The problem is that I'm in an...

Hi Guys, i'm trying to create a bell curve for returns given a level of volatility. I need to calculate the infinite degrees of freedom for every point on the bell curve. I've search all over and found various methods for calculating the various deviations but cant find out how to work out...

G H J <tbody> - 8x - 8y = 12 -8 -8 12 x= #NUM! - 6x - 6y = -102 -6 -6 -102 y= #NUM! </tbody> I am working on simultaneous equations using {=mmult(minverse(g2:h3),J2:23)}. When there is a solution it works and gives me the correct answer. When there...

Hi I'm working on some code in VBA in Excel 2010 and I'm running into a problem with preexisting code in the spreadsheet. My code reads in data from another workbook and posts the value in a certain cell, which works fine. However, there is code that is already there which causes an infinite...

I need some help for my excel vba program. I use ShellRun code to execute external program (***.exe) Public Sub ShellRun(sCommandLine As String) Dim hShell As Long Dim hProc As Long Dim lExit As Long hShell = Shell(sCommandLine, vbNormalFocus) hProc =...