So the issue is that this error message keeps popping up, but there isn't an error. I've run into it before so I have a general idea of why it occurs. The problem this time is I have the formulas in question isolated. I have 20 named ranges that I am using to dynamically fill multiple charts on an ongoing basis. Essentially, I don't want to have to select a new range every time I update the chart. The named ranges are fine and the charts using them are fine. I get the error message randomly whether it be creating a new pivot table in the same workbook or even opening another excel workbook. Once the error pops up, the data in the charts has disappeared, but the named ranges are still intact. The references within the charts are still there, but the data just isn't showing. The weird thing is that if I just save or undo, everything goes back to working perfectly. Wondering if anyone has seen this before/has any idea how to prevent the error message.