Roll Up Sheet needs daily "activation" to work
Hello, I have a Master Sheet and a Roll Up sheet based on the Master. The Roll Up uses a lot of formulas, including the "TODAY()" function. Apparently, the Roll Up will NOT refresh to reflect the data that came into the Master unless I physically go in to the Roll Up and "activate" it by scrolling around in it and re-saving it. This is absolutely ridiculous and unacceptable. Are there any work arounds? Any automated saving procedures? By automated, I mean that a human being is not necessary for it - the sheet just activates and saves itself when new data comes in. This is super important because the Roll Ups come out Daily and are very sensitive in terms of accuracy (I work in a hospital). Thank you!!!