Help me about Function->Cell()

VN

Board Regular
Joined
Aug 19, 2003
Messages
83
I do not change anything in workbook.
Why excel need to save every time when we use Cell function ?

I used function Cell() inmy worksheet on yesterday.
I open the same file to see some thing by no any changing. Why excel ask to save every time that I closed.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Cell() along with other functions such as Now(), today(), index(), indirect() and several others are considered "volatile" functions and will indeed prompt the user to save the file everytime they try to close it.

Mr. John Walkenbach covers this in his book, "Excel 2003 Formulas" on page 109
 

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,088
Members
412,764
Latest member
Brawler
Top