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.

--
R Ormerod