Solved

why using INDIRECT function prompt for " do you want to save changes?" while there is no changes made?

Posted on 2016-11-23
2
36 Views
Last Modified: 2016-11-23
why using INDIRECT function prompt for " do you want to save changes?" while there is no changes made?
0
Comment
Question by:excelismagic
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41898888
HI,

Probably because Indirect is a volatile function (like now or today)
https://msdn.microsoft.com/en-us/library/office/bb687891.aspx

Regards
0
 
LVL 3

Author Closing Comment

by:excelismagic
ID: 41898922
thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question