recalculate

I've worked with Excel 2010 for many years and have developed some very large spreadsheets. I find that the files take ages to load and then a long time to recalculate. I wondered if moving to Excel 365 or another newer version would help? Thanks Ray

Whay does excel say in the bottom status bar "calculating"... for quite some time, just when I insert a blank row, on a new blank sheet? Other sheets I can understand, but not this one, every time. Dave

Hello, I'm using an add-in that adds functions to pull data from a 3rd party program. The add-in also adds a section to the ribbon with buttons that recalculate (either the current sheet or all sheets in the book). Is there any way to activate these recalculate options in a VBA macro? They seem...

Dear All, I hope this has not been answered on this forums, I tried to search for a solution but have reached this far (see below code). The problem: I have sheet where i want to simulate a certain process. I generate random numbers and want to compare it for a value in a cell. Lets say i want...

Just wondering, why does the workbook need to recalculate when u resize a column? (my guess is, that sometimes values [such as dates] are displayed as ##### for lack of space, so it needs to recalculate those to show them...) [[[edit: my guess is probably wrong, because i just set my workbook...

Hello, all. I'm entirely new to the VBA language, and currently in a situation where I don't necessarily have time to learn it (Overseas with USMIL). I have a spreadsheet which conducts several calculations across multiple sheets, ultimately boiling down the results to a range of 4 cells. I'm...

Hey, Does anyone know how to stop a UDF from recalculating unless its target cells change? My UDF below recalculates constantly. Thanks! Function Custom_SplitandRemove3(InitialRange As String, RemoveMatchesFromThisRange As String) On Error GoTo Troubleshooter1 'Accounts for handling if...

Hello How do I get Excel to recalculate the value of NOW()? Obviously one way is to save the file and re-open it, but short of using VBA, is there any way of forcing a reculation - e.g. using a keyboard shortcut? Thanks J

I have the following formula in one of the tables. but due to large data it takes time to recalculate. how can i incorporate it into vba code? {SUMPRODUCT(RecTbl[NOD] * (RecTbl[NAME]=[@[ID]]) * (RecTbl[ TYPE]=LBal[[#Headers],[Taken]])*(RecTbl[END...

I have an excel file that crashes the excel each time I try to recalculate the workbook. If I switch the calculation option to manual then I can work on the file but as soon as I press F9 to recalculate I get the message "Excel has stopped working". There are no external links in this file. The...

I'm working in Excel 2010 with a file (6.93MB) that is not calculating. The calculation settings are set to "Automatic", I've tried Ctrl + Alt + F9, Alt + M + B, etc., but whenever I do that, in the bottom right it will show "Calculating: (4 Processor(s)): 0%" and the "Calculate" label is...

Dear mrexcel users, I am building an annual report for a company in excel. Using VLOOKUP and INDIRECT it pulls financial data from other open workbooks. (each assignment is a separate workbook, VLOOKUP pulls data from each workbook) I am using the following formula: =VLOOKUP($C6;INDIRECT("'["...

Hi, I have a file with few sheets. I have created different macros on all the sheets accept Sheet 1. Now on sheet 1 i want to create a drop down. I want that every time the value in the drop down is changed the file is recalculated. After the recalculation is completed i want it to run few...

I am trying to create a custom function that will be used on multiple different sheets. Depending on the data on each sheet, the custom function needs to calculate a few different ways. One of the inputs needed for the function to know what to do is "NumNewDiags". I currently have another...

Hello VBA and UDF world, I have a UDF/Custom Function that works the 1st Time it's ran, but when I try to use the data in a pivot table the function attempts to recalculate and returns #VALUE. I have researched this issue, came to some conclusions, but can't figure it out entirely... I found...

What's the different between: ActiveWorkbook.RefreshAll and Application.Calculate other than the latter does all open workbooks.

Hi all, I'm using windows XP, excel 2007. I've written a function (VBA below). This function (to publish the HTML of a range) works nicely when called by a macro. However I'm also trying to make it work in am excel cell. When I've got manual calculation the formula continually recalculates...

I am using RAND() to randomly select items from half a dozen lists. Each list has only 2 to 7 items in it, but I need to make thousands of selections. The problem is that every time I load the spreadsheet, RAND() automatically runs, making new selections, but I only want RAND() to run on my...

I have the following macro, which modifies a chart when the worksheet is recalculated: Private Sub Worksheet_Calculate() Sheet1.ChartObjects("Chart 1").Chart.Axes(x1Value).CrossesAt = Range("Base1") End Sub How do I get this macro to run ONLY when a data table is recalculated with F9 or...

Running Excel 2007 Windows Vista The goal is to have a VBA user defined function recalculate when any cell color is changed. So far, I have the "Automatic" selected under the "Calculation Options". I have added "Application.Volatile" to my VBA code. I have also tried, CTRL+ALT+SHIFT+F9, and...