For more info. on Palmetto's point see: http://www.decisionmodels.com/calcsecretsi.htm
For more info. on Palmetto's point see: http://www.decisionmodels.com/calcsecretsi.htm
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
So its basically this formula that could be causing it. can you confirm.
=IF(ISERR(INDIRECT("'(1)'!E14")),"",INDIRECT("'(1)'!E14"))
The workbook this is in is part of my work price estimating procedures, should i be concerned about it or is it just one of those things.
Thanks for you help.
Well, if you tried the link DKO provided you would see INDIRECT listed as one of the volatile functions. So, yes - it causes your workbook to recalculate and forces Excel to see this as a change in the file.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks