volatile

  1. D

    Refresh VBA when spreadsheets opens

    Hi, If anyone could help :confused: I want the user ID to appear in a cell Public Function user() As String user = Environ("username") End Sub All works fine, but when I send it to another user they have to click on the cell for it to update.... (hope that makes sence) could anyone...
  2. H

    Making RAND() non-volatile?

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

    Volatile named ranges? Prompts for save changes on exit

    I have a problem that I've spent way too much time trying to figure out! I need to SUM a series of named ranges. When using the range names in the SUM formula, instead of A1 cell references, Excel prompts to save changes when exiting even though no changes have been made to the workbook...
  4. B

    Indirect or Index command without recalculating forcing a save

    I am trying to use either of these two functions =INDEX (PFS!$A$1:PFS!$F$1000,(ROW()/2-2)*14+4,4)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> =INDIRECT("PFS!D"&(ROW()/2-2)*14+4)<o:p></o:p> to access cells specified by my current row position...
  5. Yard

    Multiple use of dynamic named ranges : expensive?

    Hi all, Have a reasonably busy workbook with a number of dynamic named ranges which are referred to by many formulas in many sheets. I've already converted them from an OFFSET style to an INDEX style in the belief that this will aid calculation speed (it made a small difference :mad:). Now...
    • Yard
    • Thread
    • dynamic named range index offset volatile
    • Replies: 2
    • Forum: Excel Questions
  6. B

    Custom Functions get #VALUE! results

    I have tables using a custom function on several sheets of the same format. The function works fine except for calculation issues. I've added application.volatile to the function and each sheet will update a few seconds after it's opened, but the other sheets then slip back to back to #VALUE...
  7. J

    slow SUMPRODUCT formula

    I have the following formula in my spreadsheet, and it seems to be slowing the spreadsheet considerably: =SUMPRODUCT(SUBTOTAL(3,OFFSET(I$94:I$551,ROW(I$94:I$551) -MIN(ROW(I$94:I$551)),,1))*(I$94:I$551=$A30)) Here is what I am trying to do: I have several columns of numbers. I want to count...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top