Excel save prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an Excel file which asks for a save prompt without any changes
having been made in the file.

I am using the =MID text formula in the file - is this volatile?

To my knowledge I am not using any other formulae which are volatile.

The only other reason I can think is that I have multiplecombo boxes which
have list fill ranges, linked cells and Private Sub macros on change.
 
All of the built-in functions in Excel are volatile, unless you've set recalc
to manual. So any number of cells could be updated based upon the input and
the resulting updates.
 
Not true.

Here's a list of volatile Excel functions

RAND
NOW
TODAY
OFFSET
CELL
INDIRECT
INFO

The OP's problem is not the MID function, if he has a combobox that is
enough to be prompted to save
 
Is the MID function built in?

--
R Ormerod


Kevin B said:
All of the built-in functions in Excel are volatile, unless you've set recalc
to manual. So any number of cells could be updated based upon the input and
the resulting updates.
Click to expand...
 
See my answer, he is wrong. MID is not a volatile function. A combobox will
cause this to happen
 
The mid function is a built in function of excel.

By my definition, a volatile formula is any formula that updates dynamically
as data changes. So based upon your layout and formulas, there could be any
number of updates performed based upon a value change.
 
All, or nearly all, formulas are volatile by your definiation. In
Excel, volatile functions are those which force a recalculation
without any data entry.

The OP stated that no changes were made.

Mark Lincoln
 
Back
Top