Formulas showing blank
Hi, I am having an issue with a large shared spreadsheet that is accessed using excel on the web. It has a link to a power bi dataset that makes 4 pivot tables that are then referenced by formulas ...
Forum Discussion
It might be a good idea to remove the IFERROR function from the formula so you can see what error is returned.
JKPieterse That's a good point! It gives a #REF! error but the data I'm referencing is there in the pivot table. Refresh all will get rid of the error and then the error reappears.
- I would scrutinize the GETPIVOTDATA formula and double-check if none of the filter criteria are missing from the pivot table.